Allowing read only access to a db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up some of my users to have read only access to a particular database. The forms and controls are all bound to the underlying data. A lot of my code sets settings based upon other field settings, basically automating the data entry process. My problem is that when one reviews existing data this code still runs, it is somewhat unnecessary as the saved values are already present in the recordset. When I login as my "View only" user and navigate through existing records I get run time errors stating the recordset is read only. Is there a way to know if a record being shown is an already saved record as opposed to a new record?
 
I understand you want your automation to run only for entering new records?
Well, you can check wheteher this is the state by means of the following
line of code:

If Forms("Form_Name").NewRecord = True Then ...

so you can conditionally run your code.

HTH,
Nikos

TJSully said:
I want to set up some of my users to have read only access to a
Click to expand...
particular database. The forms and controls are all bound to the underlying
data. A lot of my code sets settings based upon other field settings,
basically automating the data entry process. My problem is that when one
reviews existing data this code still runs, it is somewhat unnecessary as
the saved values are already present in the recordset. When I login as my
"View only" user and navigate through existing records I get run time errors
stating the recordset is read only. Is there a way to know if a record being
shown is an already saved record as opposed to a new record?
 
Back
Top