Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Security _ Split Db On Network Permissions Issue

Posted by: Adecypher Apr 18 2019, 10:27 AM

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!!!

Posted by: theDBguy Apr 18 2019, 10:40 AM

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

Posted by: GroverParkGeorge Apr 18 2019, 10:57 AM

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.

Posted by: Adecypher Apr 18 2019, 11:25 AM

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.

Posted by: GroverParkGeorge Apr 18 2019, 11:37 AM

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

Posted by: Adecypher Apr 18 2019, 11:47 AM

@GroverParkGoerge

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

Posted by: theDBguy Apr 18 2019, 11:55 AM

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.

Posted by: Adecypher Apr 18 2019, 11:57 AM

Great, confusion cleared thanks Sir theDBGuy,

I got it :-)

Posted by: theDBguy Apr 18 2019, 12:10 PM

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

Posted by: Adecypher Apr 18 2019, 12:19 PM

Will do, thanks again.

Posted by: theDBguy Apr 18 2019, 12:21 PM

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