Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make read only version of database
- Thread starter rana
- Start date
dschomburg
MIS
If your record(s) is/are on a form for viewing;
set the form's recordset property to 'snapshot'
or/and set the Allow Edits, Allow Deletions, Allow Additions properties to false.
That should keep um from changing anything.
set the form's recordset property to 'snapshot'
or/and set the Allow Edits, Allow Deletions, Allow Additions properties to false.
That should keep um from changing anything.
If they use a form as a table updater (or just to view entries) you can lock the fields here:
in the form editor, choose the field and right click on it, properites, 'data' Tab and set 'enable' to 'off' and 'locked' to 'on' this will give it a read only property
in the form editor, choose the field and right click on it, properites, 'data' Tab and set 'enable' to 'off' and 'locked' to 'on' this will give it a read only property
- Status
Similar threads
- Locked
- Question
- Locked
- Question