Simultaneous Input by more than one user?

[Les Coover]

MS Access 2000, NT Network Server

When one user has the database open others can not
open it. What can I do to give several users (1 to 5) access
at the same time so that data entry can occur
simultaneously. Several users accessing identical
record would occur very infrequently.

Les

 

[Rick Brandt]

MS Access 2000, NT Network Server

When one user has the database open others can not
open it. What can I do to give several users (1 to 5) access
at the same time so that data entry can occur
simultaneously. Several users accessing identical
record would occur very infrequently.

All users musty have create, modify, and delete permissions to the folder where
the mdb file is stored. This is required because the first user in causes the
creation of a locking file (SameName.ldb) in that folder. Subsequent users need
to modify that file and when the last person leaves the app the file is deleted.

If the first user has no right to create files in the folder the file is opened
exclusively (no ldb file) which is what causes the other users to be locked out.

 

[Les Coover]

All users musty have create, modify, and delete permissions to the folder where
the mdb file is stored. This is required because the first user in causes the
creation of a locking file (SameName.ldb) in that folder. Subsequent users need
to modify that file and when the last person leaves the app the file is deleted.

If the first user has no right to create files in the folder the file is opened
exclusively (no ldb file) which is what causes the other users to be locked out.

All users have access to the Server where the Access
database is located (This is called E-drive). So there
is nothing else that needs to be done so 1 to 5 users
can actively use the database at one time (edits,
new records, deletions, etc)?

Les

 

[Albert D. Kallal]

The additional users should be able to work with out problems.

You might want to check the default open setting.

Tools->options->Advanced tab

Make sure the default open mode is shared.

Once you get this working, you the need to split your database. In fact, you
should do this right away, as this is really needed thing.

You can read about this here:

http://www.granite.ab.ca/access/splitapp.htm

 

[Rick Brandt]

All users have access to the Server where the Access
database is located (This is called E-drive). [snip]

Yes, but what are their permissions on that folder? Simple "access to the
server" is not enough.

 

[Les Coover]

All users have access to the Server where the Access
database is located (This is called E-drive). [snip]

Yes, but what are their permissions on that folder? Simple "access to the
server" is not enough.

All the users have access to the folder the database is
in on the server. I did check the options setting
on the Tools > Advanced tab

Default open mode is set to "Shared"
Default record locking is set to "No Locks"
Open database using record-level locking is checked.

For no more than 5 users will this be sufficient?
Can I get by with this without "splitting the database"?

Les

 

[Rick Brandt]

All users have access to the Server where the Access
database is located (This is called E-drive). [snip]

Yes, but what are their permissions on that folder? Simple "access to the
server" is not enough.

All the users have access to the folder the database is
in on the server. I did check the options setting
on the Tools > Advanced tab

Default open mode is set to "Shared"
Default record locking is set to "No Locks"
Open database using record-level locking is checked.

For no more than 5 users will this be sufficient?
Can I get by with this without "splitting the database"?

We seem to be having a communication problem.

What do you mean when you say "...users have access to the folder..."? I can
give you access to a folder but not let you edit, delete, or create files within
that folder. Are your users able to do those things in the folder where the mdb
files resides?

 

[Les Coover]

All users have access to the Server where the Access
database is located (This is called E-drive). [snip]

Yes, but what are their permissions on that folder? Simple "access to the
server" is not enough.

All the users have access to the folder the database is
in on the server. I did check the options setting
on the Tools > Advanced tab

Default open mode is set to "Shared"
Default record locking is set to "No Locks"
Open database using record-level locking is checked.

For no more than 5 users will this be sufficient?
Can I get by with this without "splitting the database"?

We seem to be having a communication problem.

What do you mean when you say "...users have access to the folder..."? I can
give you access to a folder but not let you edit, delete, or create files within
that folder. Are your users able to do those things in the folder where the mdb
files resides?

Yes users can edit, delete, or create files within
that folder.