Hi there,
I am using access 2010. I split the database and would like one user to be able to edit and other users to read only. Please explain the step involved
Hi there,
I am using access 2010. I split the database and would like one user to be able to edit and other users to read only. Please explain the step involved
Need to identify the users. Either hard code the user privileges or create a users table with defined privileges. Identify the user when the db is opened either by login procedure or pull username from the network login. Open forms in mode appropriate to the identified user.
However, be aware that holding down the shift key will override many optional database settings and bypass code execution on open which means the db is wide open to anyone. F11 will also expand/collapse the navigation pane. Unless you want to publish the db as an executable.
Login and user privileges are common topics. Search forum or web.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you very much for your response. I was able to create the user and security table for the User Level Security on the dbase but I have a search text box will filters the customers names and takes to the required record it is not filtering. the open event i have allowedits, allowdeletions and allowadditions set to false. Any ideas?
Would have to review code. Suggest not trying to set those properties directly with code. Leave them all set to Yes. Then use OpenForm arguments:
Docmd.OpenForm "form name", , "filter criteria here" , , acFormReadOnly
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.