Link to home
Start Free TrialLog in
Avatar of gcgcit
gcgcit

asked on

Macro Error

I have an Access 2010 database.  When I try to run it from my machine it works great but when I try to run it from another machine I get this error (see attached screenshot).  We are both using a desktop shortcut to the exact same application sitting on our server.  How do i fix this?  User generated image
Avatar of Nick67
Nick67
Flag of Canada image

Are you both using the same version of Access?
Are you both usng the same version of Windows?
Are you both using 32 bit or 64 bit Windows?
Could be a linking issue.  I get the same on one of my databases, if it is moved to another computer where the back end needs to be relinked.  If this is a split database, try canceling out of the macro error and relinking.  To prevent the error in future, after moving the database, open it by Shift-clicking in the Explorer pane, to avoid running the macro, and do the relinking.
Is your Access database split in FrontEnd or BackEnd?
If so, what about the user Access to the BackEnd on network?

HTH,
Daniel
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you are using an AutoExec macro, you might be able to move to VBA code run from the Load event of a main menu.  As boag said, VBA is a lot better at handling errors.