CODEWITHSUNDEEP
ms-access
Alex Gordon
Alex Gordon

Reputation: 60721

ms-access: file already in use ERROR

i have an access backend MDB

it is supporting multiple user connections

every user has their own access front end

for this one particular user (her permissions arent any different from other users) she is getting FILE ALREADY IN USE error when she tries to open this database using her front end

if you have any suggestions please let me know asap, as this is urgent for me

Upvotes: 0

Views: 3363

Answers (2)

Tony Toews
Tony Toews

Reputation: 7882

But are this users permissions for the BE Access database file folder different than the others? Can that user create, update and delete a txt file using Notepad in the same folder as the BE?

Upvotes: 2

PowerUser
PowerUser

Reputation: 11781

In her front-end, go into Tools->Options->Advanced. Change the default Open mode from Exclusive to Shared.

Upvotes: 1

Related Questions