look for VBA codes to make Tables and Quries to be READ ONLY

M

Moz

Anyone out there knows how to write VBA codes to make the Tables and
Queries to be "READ ONLY" in a database, so when we convert that
database to a "MDE" mode, the user can run application, view but not to
alter the design of Tables and Queries. Your help is much appreciated.
 
L

Lynn Trapp

If you implement User Level Security, you can put the appropriate users in a
Read Only group and then give them access to the data via RWOP Queries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to obfuscate VBA code? 6
Securing BE content without a Workgroup 4
program to make Tables and Queries becomes READ ONLY 3
Best way to deploy Access read-only database that is linked to SQL tables 6
Unable to Step Into VBA Code 0
problem with permitions on make tables queries 7
Prevent Importing / Linkage via Security 3

Top