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

Need Help To Create a MDE with certain Items Available 2
Securing BE content without a Workgroup 4
Prevent Importing / Linkage via Security 3
Make table data read-only to external Access mdbs 3
Best way to deploy Access read-only database that is linked to SQL tables 6
How to prevent importing tables 53
ULS Update/Delete Permissions not working 5
Problems with ULS, i.e., removing permissions from tables 5

Top