Simplest of tips - if you've recently had Access upgraded to 2007 and try and open a database on a network share with macros you get a bunch of security prompts. Rather than go through the process of allowing them each time.
Click on the office logo
Click on Access Options
Click on Trust Center
Click on Trust Center Settings
Click on Trusted Locations
Tick the box next to Allow Trusted Locations on my Network (not recommended)
Click on Add New Locations
Select drive (directory optional as is the 'include subfolders' tick box
OK your way out of there!
This came up because our HDMS databases are on a network share