I have my tables on a server running SQL Server 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.<BR>How do I capture the users permissions when opening a form so that I can lock it using the AllowEdits function if the logged in users account is read only?<BR><BR>Or is there a better way to handle this cause my forms still allow data editing to be done even if the account is read-only. It generates an error when the user tries to move to the next record.<BR><BR>Thanks<BR><BR>