If you're using Access 2007, you'll want to download this hotfix. It addresses a number of problems, including slow performance when sharing a database over a network.
A new hotfix for Access 2007 is available, as noted on the Access Team Blog December 30, 2008. It fixes the following problems:
- Loss of changes to code module.
- Subform displays nothing after setting main form's recordset.
- Slow performance when sharing database over a network.
- Serious bloat when opening and closing forms.