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

[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

 

[Daniel Pineault]

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.

 

[chapfam5]

hi david
how are you

 

[David Raveh, MD]

It was very good.
Thank you very much indeed.
David
+++++++++++++++++++++++