More than a user to access the db at the same time

[ocp&mcsd]

Hi all
How are you?
I have a small problem...
I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server.
I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry).
The problem is that users from there local machines can not access the BranchDB at the same time.
What can I do?
Your help will be highly appreciated.

 

[Dreamweaver]

Give a copy of BranchDB to each user that way they arn't all using the same front end which can cause problems.

mick

 

[ocp&mcsd]

That is what I did before posting this post...

I still facing the problem....

 

[Dennisk]

sound like a permissions problem with the folder and users.

 

[ocp&mcsd]

No
Not a permissions problem.
I gave all users full permissions on that DB.

 

[Dennisk]

no a network permissions problem.

 

[MicroE]

What is the exact error message users are receiving when trying to open the db at the same time?

http://www.myaccesstips.com/deploy/deploy.html

 

[The_Doc_Man]

Two reasons can exist to cause this problem.

1. Failure to properly secure the database. If everyone is using the default workgroup because a secured version wasn't created, then everyone comes in as ADMIN and the Admins group members have OpenExclusive permission.

Fix: Search this forum for "Securing a Database" and "Workgroup Security" topics. You'll see LOTS of posts.

2. Missing specific permissions on the .LDB file (and by implication, all files) to allow create/delete/update on the lock file. Search the forum for "Windows Permissions" or "Folder Permissions" to see many posts on this topic.

 

[ocp&mcsd]

http://www.myaccesstips.com/deploy/deploy.html

It works...