Simultaneous Input by more than one user?

  • Thread starter Thread starter Les Coover
  • Start date Start date
L

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
 
Les Coover said:
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.
Click to expand...

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.
 
Rick Brandt said:
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.
Click to expand...

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
 
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
 
Les Coover said:
All users have access to the Server where the Access
database is located (This is called E-drive). [snip]
Click to expand...

Yes, but what are their permissions on that folder? Simple "access to the
server" is not enough.
 
Rick Brandt said:
Les Coover said:
All users have access to the Server where the Access
database is located (This is called E-drive). [snip]
Click to expand...

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

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
 
Les Coover said:
Rick Brandt said:
Les Coover said:
All users have access to the Server where the Access
database is located (This is called E-drive). [snip]
Click to expand...

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

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"?
Click to expand...

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?
 
Rick Brandt said:
Les Coover said:
Rick Brandt said:
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.
Click to expand...

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"?
Click to expand...

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?
Click to expand...

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