I have a database where users are occasionally getting an error when trying to open forms or reports. This does not happen all the time, it happens on various forms, for various users on various machines and I have not found any other consistent factor such as time of day or other open applications (just to be sure), which makes the problem hard to identify.
There are two forms containing buttons for all the various forms or reports. The embedded macros for each button seem simple and straight-forward Action: OpenForm
Argument: FormName, Form, , , , Normal
(Italicized FormName would, obviously, be the name of the form)
This is a split database where both the front and and back end are stored on the network in different folders and users have a desktop shortcut to the front end.
I ran a compact and repair today hoping that will fix it, but in the meantime if there's any other advice I'd appreciate it.
Update: I am working with Access 2007 on Vista Business 32-bit at the office. Occasionally I work on the front end at home using Access 2007 on Windows 7. However the problem doesn't seem related to when I do this - just wanted to mention in case it is.