Running macros from a network drive

[Guest]

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.

 

[Joseph Meehan]

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.

I suggest that you split that database. Each user having a front end
and all the data on the server as the back end.

Look up split database in the help file and it will direct you to the
wizard that will do it for you. Always make a copy of your database before
doing this and make sure everything is working well before getting rid of
it.

This may not fix you problem, but it may and it should be done anyway.