I am having a problem with multiple users attempting to open the same Access DB. When to users simultaneous try to access the db, an error occurs.

How do you check to see if the DB is able to be written to (not being written to by someone else)?

I am using the command
Set DB = Workspaces(0).OpenDatabase("dbname.mdb").OpenRecord("record") with the dbOpenDynaset

Thanks for the help!
Raymond