Access 2002 data protection

[Guest]

I want to prevent users from changing the data in the Access 2002 file I
built, but allow them to develop their own queries to run against it. Is
there a way to do this? I tried making the database file read-only, but that
prevents query development.

 

[Van T. Dinh]

Get the user to create a new MDB file and simply link the Tables from your
Read-Only Back-End MDB file to the new MDB as linked Tables.

In the new MDB file the user has Read/Write access so he/she can create
Queries as required but the data will be Read-Only.

Note that this is by no means a security measure! Any user with a bit of
knowledge will find your Back-End database and depending on his / her
(network) permission, he/she may be able to remove the Read-Only flag on
your Back-End MDB file.

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Thanks, Van! I followed your suggestion and got it to work. I'm not so
concerned about security as protecting the data from user oopses, so your
approach is fine for that.

 

[Van T. Dinh]

You're welcome ... Glad that the method is suitable for your needs.