Two thoughts:

1. Your system.mdw file may have gotten corrupted. You can create a new
one in Access with Tools Security Workgroup Administrator and blow
away the old one.

2. I find it's better to explicitly define the Database, Recordset, etc
objects of DAO. For example, instead of Dim db As Database, write Dim
db As DAO.Database. This is especially true if your code has any
references to other data access components.

OK, 3rd thought: You might also check C:\Program Files\Common
Files\Microsoft Shared\DAO\ and check what library everyone has
installed. The latest is DAO 3.6.. Some users may not have the older
DAO 3.51 version installed, causing a run time name resolution slow
down.


----
Nick Hebb
BreezeTree Software
http://www.breezetree.com