number of concurrent users???

  • Thread starter Thread starter bob engler
  • Start date Start date
B

bob engler

I have an Access MDB running on a Windows server. When there are 2
users accessing the DB (Open databases using record-level locking is
set), no-one else can open the DB. When it is clicked or the Open is
clicked,
nothing happens, no error messages. Is there something that is limiting it
to only 2 users at a time. When the users close the DB, other users can then
access it.


Thanks.......
 
Do all the users have full access to the folder where the MDB file exists?
(Read, Write, eXecute, Delete)
 
Yes, they do and they can open it when others aren't using it. There is a
lock file created when it is opened but with 1 user working with it, 1 more
user can access and use it but not others until the lock file goes away.

Thanks...
 
Are they perhaps opening the database in Exclusive mode?

How are they opening: through a shortcut, by double-clicking on the MDB
file, or by opening Access then selecting the MDB file from within Access?
 
They were trying to open it by clicking the MDB file. I unchecked the
Exclusive mode
on the USers and Group but it still has the smae problem. When I get them to
open
Access first and then File-Open-FN, everyone can use it (I saw this in
various groups).
Is there some problem why clicking on the MDB file doesn't work?

Thanks for all your help....
 
I suppose it's possible that the default file association for MDB files has
been set up to open the database exclusively.

In Windows Explorer, select Tools | Folder Options and go to the File Types
tab. Find the entry for MDB files, and click on the Advanced button. Check
what's associated with the open action by selecting open from the Actions
list, then clicking on the Edit button. Check that the string that's in the
"Application used to perform action" doesn't have a /x flag in it.
 
Is the database a "split" database. (a FE and BE type of setup) AND are
the users opening their own version of the FE?
 
Back
Top