program to make Tables and Queries becomes READ ONLY

[Moz]

Anyone out there knows how to write a code to make the Tables and
Queries to be "READ ONLY" in a database, so when we convert that
database to a "MDE" mode, then everthing is secured?
Your help is much appreciated.

 

[Douglas J. Steele]

No, there isn't.

If you use only queries, and have DISTINCT in each of the queries, you won't
be able to update the data through the forms. However, you'll still be able
to get to the tables by linking to the database.

Note that your application should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the front-end needs to be
converted to an MDE: there's no advantage to be realized converting the
back-end, as creating an MDE only impacts code-related components of your
application.

 

[Dave Bolt]

Totally untried solution.
Split the data and code parts of the database, and put the data onto CD or
give normal users only read access rights to the file (using NTFS security).
Dave

 

[Moz]

Thank you, It is a good alternative....

Moz

Totally untried solution.
Split the data and code parts of the database, and put the data onto CD or
give normal users only read access rights to the file (using NTFS security).
Dave