|
I don't have an exact answer for you but the Access database can be accessed by multiple users at once. You may need to set an instruction in Access to perform record-level locking instead of table-level - I'm not sure what the default is.
Do a Google search for "multiuser access" and you'll find some advice. If this is an important database I recommend splitting the code from the tables as one of the articles explains. I support an Access database where everything is in one MDB file and it's tedious when I need to make changes, however it's used concurrently by 3-4 users just fine.
__________________
How you do anything is how you do everything.
|