tags:

views:

56

answers:

2

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

+1  A: 

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

PowerUser
+2  A: 

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?

Tony Toews
That is, are all the users of the database members of the NTFS security group that is being used to grant permissions on the folder and share where the back end is stored?
David-W-Fenton
David, thanks for the clarification.
Tony Toews