How to lock MDB file: allow data entry but not re-design?

  • Thread starter Thread starter David Raveh, MD
  • Start date Start date
D

David Raveh, MD

May I ask: I have an MDB questionnaire file for data entry. I would like to
send it to several usrs to fill in data and to get the file back for
analysis. But I would like to "lock" the design/program so the users will be
able only to enter data and not to make any intentional/mistaken changes in
the design/program.
Thank you for your assitance.
David
 
Yes, this can be done very easily!

prior to 2003:
Make mde
see:
http://www.databasedev.co.uk/microsoft-access-mde.html
http://www.databasedev.co.uk/converting-ms-access-files.html

2007:
make accde
see:
http://www.databasedev.co.uk/convert_to_accde_format.html

In all cases, make sure you keep your original file safe for futur changes!!!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top