MS Access Macros keep disappearing.
We have a server using an Access Database as the "back end" for a simple web query form. The clients have no access to the database at all. About once a week, the macros totally get deleted and we have to put them back. We have set the "allowed locations" for macros and allowed macros to run in the Access Database Options. Everything was working fine for over a year and just about a month ago, the macros started getting deleted at least once per week. What could be causing this to happen? They still exist in the system but the front end application stops functioning and we have to re-import them.
John Tsioumpris
How about compiling the Access
Rather than reimporting the macros into the existing FE, why don't you simply copy the master database and use it?
Or better yet, create an application launcher (generally a bat file) which will copy the master database onto the users computer and launch it, every time they run the application launcher.
Dale
Or better yet, create an application launcher (generally a bat file) which will copy the master database onto the users computer and launch it, every time they run the application launcher.
Dale
Are you using Access as the Frontend? You mention a web query, so are you instead using Access with a web page of some sort?
What do the macros do?
What do the macros do?
ASKER
Hi
The Macros update the backend database. The users only interface through a web portal.
Thanks
The Macros update the backend database. The users only interface through a web portal.
Thanks
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.