Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / September 2006

Tip: Looking for answers? Try searching our database.

DESIGN VIEW SECURITY

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tijan - 12 Sep 2006 19:32 GMT
HELLO
      HOW CAN I GIVE SECURITY TO THE DESIGN VIEW TO PREVENT ANYBODY NOT
CHANGING ON IT.?
Signature

TIJAN
THANKS TO THOSE PEOPLE WHO
I DONT KNOW,
AND THEY ARE TRYING TO HELP ME

Jerry Whittle - 12 Sep 2006 19:47 GMT
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.
Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> HELLO
>        HOW CAN I GIVE SECURITY TO THE DESIGN VIEW TO PREVENT ANYBODY NOT
> CHANGING ON IT.?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.