[X]My Assistant

[Adecypher]

Hi All,

I have an Access 2010 app which is setup to work in a split format (i.e. Front End with forms and queries etc - and Back End with data tables only). I have this app on our network setup and it is working fine. But when I installed/Setup on a user's site I am not able to write to the back end tables in other words when I open the app it freezes, the IT at the site says the users have read access to the folder which has the DB is that enough? what exactly they are missing in access privileges on their end.

BTW I never face such issue at our work location.

Advice and suggestions will be appreciated!!!

[theDBguy]

Hi. All db users trying to connect and modify the BE file should have read/write/modify/delete permissions to the BE folder.

[GroverParkGeorge]

The issue is with the Locking file that Access creates when anyone opens the accdb. It's called lccdb. Each user MUST be able to create that lccdb, update it (if they open the accdb after someone else has already opened it) and delete it when they are the last person to close the accdb. That means ALL users must have the permissions outlined.

[Adecypher]

Please confirm/correct my understanding as stated below:

So the requirement for a locking file to successfully be created and or modified (and at some point get closed when no one is using the DB) by each user is for that user to have read/write/modify/delete permissions for the BE stored on a network folder.

[GroverParkGeorge]

Not quite. For the NETWORK FOLDER itself, along with any files in it that need to be modified....

[Adecypher]

@GroverParkGoerge

I thought the file scope is limited to .accdb and associated laccdb, please can you elaborate your response...I am now little confuse.

[theDBguy]

Hi. If you read my first reply above, I said "BE folder," which means if your BE's name is MyBE.ACCB and you are storing it on a network share like, X:\DepartmentName\Databases\MyDB\, then all users of MyBE.ACCDB will need "full" permission to the folder \MyDB\ on the network computer.

[Adecypher]

Great, confusion cleared thanks Sir theDBGuy,

I got it :-)

[theDBguy]

Hi. Glad to hear it made sense. Please let us know how it goes. Good luck!

[Adecypher]

Will do, thanks again.

[theDBguy]

You're very welcome. George and I were happy to assist. Cheers!