Shared Dbase

[Todd]

My database is split into FE / BE and I've got security permissions set up.
I've got the FE (which I create an exe to deploy to users) and BE portion set
to shared from the options menu. When a user is logged in and another user
tries to login it gives an error message that the dbase is already in use by
another user and it doesn't allow them to login. If I log in while someone
is already logged in I can still get in (I'd assume because I'm the
administrator).

Am I missing something with sharing a database? Is there something else
that I haven't setup correctly? When I view the directory where the database
BE resides I can see the recording locking file (ldb) and I'd assume that
signifies that a user is logged in.

Help!

 

[John Spencer]

Do all the users have read, write, and delete privileges to the
directory where the backend database is located? They must have the
ability to create and delete the lock file. If they don't then first
one gets exclusive access to the backend database.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================