I have my tables on a server running SQLServer 2000 and the front-end in an Access 97 database. I have setup some user accounts in SQL Server for the staff to access the database. Some of these are read only.

How do I capture the users permissions when opening a form so that I can lock it using the AllowEdits function?