S
stasamation
I have a FE/BE database. The BE resides on the network. Some of the
users have read-write permissions to the BE and some have read-only
permissions. (Permissions are set via standard Windows security).
I am looking for a way to check if the BE is read-only -- what I want
to do is enable or disable certain GUI buttons accordingly. In other
words, for those users who have read-only permissions to the BE, I
want to disable such buttons as "Edit" and "Delete". My plan is to
put this code in the "On Load" event of various FE forms.
How can I check if the linked BE is read-only? Also, should I be
checking if the file permissions are read-only or is it better to
check if the recordset is updatable?
users have read-write permissions to the BE and some have read-only
permissions. (Permissions are set via standard Windows security).
I am looking for a way to check if the BE is read-only -- what I want
to do is enable or disable certain GUI buttons accordingly. In other
words, for those users who have read-only permissions to the BE, I
want to disable such buttons as "Edit" and "Delete". My plan is to
put this code in the "On Load" event of various FE forms.
How can I check if the linked BE is read-only? Also, should I be
checking if the file permissions are read-only or is it better to
check if the recordset is updatable?