DESIGN VIEW SECURITY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELLO
HOW CAN I GIVE SECURITY TO THE DESIGN VIEW TO PREVENT ANYBODY NOT
CHANGING ON IT.?
 
For forms, reports, and modules, you could convert the database to an MDE
file. Just make sure that you keep a copy of the MDB file to make future
changes.

For tables and queries you'll need to implement user level security and all
the fun of that.

You could hide the database window by going to Tools, Startup and
un-checking the database window box. However a smart user would know that
just pressing the F11 key unhides the database window.

You can also hide tables, queries, etc., by putting Usys in front of the
object name as the first 4 characters. Then going to Tools, Options, View,
and ensure that the System objects box in unchecked.
 
You must log in or register to reply here.

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

File Download - Security Warning 5
How to lock viewing Form Design. 4
Access 2007 queries will not open in design view 5
Cannot see fields in query design view on laptop; Access 2003 1
Using Wild Cards in Paramter Querry 2
secure my access problem, Importing the Database. 7
How to Restrict Users to view/go to Query Design/Sql mode in MDE/M 4
Access stripping decimal places in query 1

Back
Top