Running macros from a network drive

V

vanGogh

I copied an Access application that was developed on my machine to a network
share drive.

I then put a shortcut to this Access application on the desktops of a few of
my users.

Users can access the forms and view data from the application, HOWEVER, if
users try to generate reports (which are based on VB code called from a
macro), a VB compilation error is generated.

The error states "There was an error compiling this function. The Visual
Basic module contains a syntax error. Check the code and then recompile it."

Has anyone out there ever seen this error?

Does anyone have any suggestions about how to go about fixing it?

Any suggestions would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top