UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Split Db On Network Permissions Issue, Access 2010    
 
   
Adecypher
post Apr 18 2019, 10:27 AM
Post#1



Posts: 111
Joined: 3-October 14



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!!!
Go to the top of the page
 
theDBguy
post Apr 18 2019, 10:40 AM
Post#2


UA Moderator
Posts: 76,904
Joined: 19-June 07
From: SunnySandyEggo


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

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Apr 18 2019, 10:57 AM
Post#3


UA Admin
Posts: 36,203
Joined: 20-June 02
From: Newcastle, WA


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.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Adecypher
post Apr 18 2019, 11:25 AM
Post#4



Posts: 111
Joined: 3-October 14



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.
Go to the top of the page
 
GroverParkGeorge
post Apr 18 2019, 11:37 AM
Post#5


UA Admin
Posts: 36,203
Joined: 20-June 02
From: Newcastle, WA


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

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
Adecypher
post Apr 18 2019, 11:47 AM
Post#6



Posts: 111
Joined: 3-October 14



@GroverParkGoerge

I thought the file scope is limited to .accdb and associated laccdb, please can you elaborate your response...I am now little confuse.
Go to the top of the page
 
theDBguy
post Apr 18 2019, 11:55 AM
Post#7


UA Moderator
Posts: 76,904
Joined: 19-June 07
From: SunnySandyEggo


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.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Adecypher
post Apr 18 2019, 11:57 AM
Post#8



Posts: 111
Joined: 3-October 14



Great, confusion cleared thanks Sir theDBGuy,

I got it :-)
Go to the top of the page
 
theDBguy
post Apr 18 2019, 12:10 PM
Post#9


UA Moderator
Posts: 76,904
Joined: 19-June 07
From: SunnySandyEggo


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

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Adecypher
post Apr 18 2019, 12:19 PM
Post#10



Posts: 111
Joined: 3-October 14



Will do, thanks again.
Go to the top of the page
 
theDBguy
post Apr 18 2019, 12:21 PM
Post#11


UA Moderator
Posts: 76,904
Joined: 19-June 07
From: SunnySandyEggo


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

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2019 - 03:37 PM