More information would be good since you've really told us absolutely nothing
so far! What exactly does
won't run properly in Access 2007.
mean?
As a wild guess, because no one can do anything else from the info on your
original post, in version 2007, no VBA code will execute unless the folder
holding the database has been designated as a “trusted†location.
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)