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.

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.

Show quoteHide quote

Secured Database works exactly right on one computer, but on another not quite r
The database has been placed in a state...
Is it any way to programmatically store and hide data inside an Access database that it is not shown
Mystery security group setting changes.
RWOP query, forms and security
Locked by ADMIN or Exclusive Access
Unrecognized database format 'C:\Program Files\Microsoft Office\OF
Passwords
Locked out of Access
Still can access my mdb using the default system workgroup file