Manage Users and permissions Access 2010 (1 Viewer)

[Timoo]

Hi txGeekGirl,

thanx for your reply.
Am I correct when I say that if I give read & execute-access to a user on a folder, in order to use an accde-database, they can alter the data?
That is for me how it seems to be.

What I want to do is to have a user-login for some people to have read & write access and for others to have only read-access on the database. Any idea how to manage this?

Thanks in advance,
Timo

 

[txgeekgirl]

What I hate about Access 2010 is the way you have to lock down a DB so that the End Users don't screw it up! I have massive problems with this and then after all of the coding and seeing that it worked at the server level - when RDP'd into, some of the locks don't trigger.

So - we have taken precautions - like splitting the DB from the data, removing the ribbons on both Login and Switchboard load

Private Sub Form_Open(Cancel As Integer)

DoCmd.ShowToolbar "Ribbon", acToolbarNo

End Sub

Hiding the Nav Panel - Tip 3
http://www.pcmag.com/article2/0,2817,2386971,00.asp