[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1261
  • Last Modified:

Multiple connections to Access Database?

I'm having trouble with users not being able to access a single Microsoft Access Database at the same time.

When one user opens it up, it says it will open in read only mode because another user has another copy open.

Can I disable this feature?

Thanks
0
snyderkv
Asked:
snyderkv
4 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  Make sure all users have full privs for the directory where the MDB resides.

JimD


 
0
 
peter57rCommented:
The likely cause for this  is that you have not given users adequate permissions on the folder containing the database files.
Users must have full permissions on the folder because Access involves creating, modifying and deleting files when it is being used.
If you are not sure whether users have those permission see if they can create and delete a Word or XL file in the database folder.



0
 
Arthur_WoodCommented:
Set the MDB to open in Shared Mode by default -

From the Menu bar, choose Tools>Options.Advanced tab - set Default Open mode to Shared.  Then close the MDB, and after that multiple users can open the MDB at the same time.

Is the Application structured as a Front-End/Back-End?

The Front-End MDB holds all the Forms, Reports and Queries, and LINKS to the Back-End MDB which holds only the REAl data tables, but no forms, Reports or queries.

AW

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
snyderkvAuthor Commented:
Ok it was shared and we went ahead and put more share and NTFS permissions on it.
0
 
Arthur_WoodCommented:
Is the Application structured as a Front-End/Back-End?

AW
0
 
snyderkvAuthor Commented:
Fixed the problem. The issue was with not only the security permissions to the database but some users had shortcuts on there desktop that pointed to the old server (but same share) I deleted and recreated them.

Thanks for the help
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now