Two things come to mind!
First off, does any VBA code run? Have you declared the Folder the Database resides in as 'Trusted?' To allow Code to run in 2007/2010 declare the Folder as ‘trusted’.
To trust your Folder, click:
- Office Button (top left)
- Access Options (bottom of dialog)
- Trust Center (left)
- Trust Center Settings (button)
- Trusted Locations (left)
- Add new location (button)
Secondly, when apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, you also have to think about are missing references.
If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:
Access Reference Problems
Could be one or the other, or both of these!
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007