Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > Access Updater >
Back to Access Updater    Comments List
Access Updater Upload Images   Link   Email  
Albert Cepeda      
17 months 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             
17 months 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       
17 months ago
Yes. This happened to me. I had the exact same function twice and deleted one.
Albert Cepeda      
17 months ago
Renaming the IsLoaded function in the Access Updater did the trick.  Thank you.
Richard Rost             
16 months 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             
16 months 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      
16 months 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             
16 months 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.

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

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/20/2024 12:04:59 AM. PLT: 1s