User logons

J

Javlin

How many users can be logged on to an Access 2000 database at one time? Each
are using an Access front end. From what I can tell, there is a network
Access database that many users have, in the past, been logged on
simultaneously but now it will allow only one or two. If Access does allow
multiple users to be logged on at the same time, which is what I thought,
does anyone have an idea what my problem might be? Permissions are not an
issue and no group policies have changed or implemented recently.
 
J

James Goodman

The maximum number of users is 255. This is taken from the Access
Specifications & will vary with different versions...
 
J

Javlin

Sorry, the problem is that when trying to open the .mdb file it brings up an
error message that says "Could not use <path and filename>; file alreaqdy in
use"
 
R

Roger Carlson

This is usually a network permissions issue. I know you said it was not,
but this is the usual problem. It would be worth it to check again. Every
user MUST have READ, WRITE, MODIFY, and DELETE permissions to the
**DIRECTORY** where the application lives. If they do not, the first user
gets to open the database, but since they cannot create the LDB file (no
create permissions) Access thinks they've opened it exclusively. Therefore
no one can get in.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
J

Javlin

Thanks Roger - that did it. The group many belonged to had all but the write
permission. I appreciate the help!
 
Top