I have an Access ADP with the ADP file is saved on common / shared drive & Directory which all workstations can read and write to. The application is run using Access 2000 runtime version. The application has a standard custom menu for most forms with a Functions menu rebuilt through VBA code evertime a different form becomes active.

The menus work fine for first person to load the adp however everyone else gets an error message "Can't find macro ..... The macro doesn't exist or the macro is new and hasn't been saved". This error only occurs with the standard menu options. The dynamically menu options seem to work fine.

Can anyone tell me what might cause this problem or point me to
somewhere I might find the cause and a fix?

Ash

Sounds like a conflict between the different users.

Letting users use the same front-end database is never a good idea. Install a copy on each of your users machines and I'll (almost) guarentee the problem will go away!


Brian Skelton
Braxis Computer Services Ltd.

Brian

Thanks for the suggestion. Having separate copies of the front end files for each user does avoid this problem, however, the client's IT Unit have a strong preference for a single central copy. I assume it is to make their job for distribution / maintenance easier (but they could also just be a bit retentive).

I have tried building part of the menu dynamically through VBA code and this seems to fix the problem. Unless I find the cause and a different solution I guess I will be building the entire menu through VBA code at runtime.

Ash

Why not place a batch file on the server that the users can click on to launch your application?

Assuming your ADP isn't too big, the batch file could delete any old copy of the database, copy a new version to the users local drive and then launch the database.

This should solve the menu problem, speed up your database, and keep the IT department happy.


Brian Skelton
Braxis Computer Services Ltd.