DB sharing (1 Viewer)

Kundan

Registered User.
Local time
Yesterday, 23:51
Joined
Mar 23, 2019
Messages
118
We have a n/w of 3 comps. Access db is installed on 1 comp and all access it. When I access the db when another user is already accessing it, I get a message "You do not have exclusive access to the database this time. If you proceed to make changes, you may not be able to save them later."

How can we avoid this?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:51
Joined
May 7, 2009
Messages
19,169
make a shared folder.
add Everyone to its user.
on Advace sharing, make sure to grand "Full Control","Read","Write" to Everyone.
split the db (FE/BE) (on Ribbon, Database Tools->Move Data->Access Database) and save the BE to the shared folder.
open the FE.
relink the FE (front-end) to the BE (External Data->Linked Table Manager).
tick all tables and queries).
on the bottom, tick "Always prompt for a new location". press OK.
on the "New Location Pop-up"->File Name, type:

\\yourComputerNameHere\SharedFolderNameHere\theBENameHere.accdb

after successfully relinking, give a copy of the FE to your users.
 

Users who are viewing this thread

Top Bottom