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.
marshaweinmannNetwork ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
How about compiling the Access
Dale FyeOwner, Developing Solutions LLCCommented:
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.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
marshaweinmannNetwork ManagerAuthor Commented:

The Macros update the backend database.  The users only interface through a web portal.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.