Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > Access Updater >
Back to Access Updater    Comments List
Upload Images   Link   Email  
Access Updater
Albert Cepeda 
    
2 years ago
Hello Richard,
I'm trying to setup the Access Updater and am following your instructions.  After I press "Push Update" I eventually get an error message from the Sub DoExit saying Compile error: Ambiguous name detected IsLoaded.  Can you please help me with this?
Richard Rost 
          
2 years ago
Sounds like you have another function named "IsLoaded" in your VBA somewhere. Do a global search for it. You'll need to rename one of them.
Eduardo Benaim 
     
2 years ago
Yes. This happened to me. I had the exact same function twice and deleted one.
Albert Cepeda OP 
    
2 years ago
Renaming the IsLoaded function in the Access Updater did the trick.  Thank you.
Richard Rost 
          
2 years ago
Just make sure you also rename any other code THAT CALLS THAT function. If you rename mine to IsLoaded2 then make sure you find who uses that and change that as well.
Richard Rost 
          
2 years ago
Moving forward, I should probably make all of my functions that are designed to be dropped into other peoples' database start with a custom prefix, like alzIsLoaded() or something. :)
Albert Cepeda OP 
    
2 years ago
Sounds good.  I have a follow-up question about using Updater with ACCDE files.  I read your instructions.  Are you saying I need to manually change the LocalDB in the Settings File to a .ACCDE extension?  I tried that and it does push the update as an ACCDE, but the file is still an ACCDB.  I know this because when I open the ACCDE on the server, it still allows for design edits and it shouldn't.  What am I doing wrong?  It would be great if you included this step in your video. I know, I'm asking too much.  :-)
Richard Rost 
          
2 years ago
The updater doesn't change anything as far as the file extension or the database type. It's going to literally push whatever you tell it to push. So what you have to do is create the ACCDE file yourself, specify that as the local copy that's going to get pushed and then that should get copied to all your workstations. If they can still open up the database and design stuff then you didn't create the ACCDE right.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Updater.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/12/2025 7:03:32 AM. PLT: 1s