Multiple users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database running on 2 computers. I have split the DB so
that the tables reside on one computer; the forms, queries, etc. are
duplicated on each computer. Altho' the DB is set to 'Shared', when one user
has the DB open, the other user gets an error message "File already in use"
when they try to open any data forms, etc. in the DB. Static forms (menus,
etc.) open OK. Any help would be appreciated.
~KK
 
Do the users have full Windows permissions to the folder in which the
database lives? They must be able to create, update, and delete the locking
file created when a user opens a shared database.
 
Rick,
That was it; missed one subfolder in the sharing settings. Thanks.
~KK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclusive use error code in shared database 1
Opening a db 2
Database Splitter Slow Performance 4
Access how to open existing database from another database using Access - VBA 0
Multiple users accessing the DB 1
Retrieve Data from a Network shared drive backend database. 4
Modifying a DB from multiple systems at the same time? 3
Import Users and Permissions? 1

Back
Top