securing a database

[Mark]

Hi all,

I wanted to find out how to make a database more secure.
As in, when you go to open up a database file and
press "shift" + "enter" and the screen where the tables,
queries, forms, etc. are located is displayed... I would
like to disable this function. It is to my knowledge that
using the shift plus enter is used by Access to get to the
back screen of all databases. And besides using a
password protection means is there another way of locking
down a database?

Thanks for any advice!

 

[Scott McDaniel]

This link takes you to code to disable that:
http://www.mvps.org/access/modules/mdl0011.htm

However, merely disabling the shift key doesn't really do much in terms of
security, and setting a database password is basically useless. If you want
any modicum of security, you'll need to implement User Level Security, and
that is a tricky and complex beast. If you decide to go down that path,
please do so on a copy of your database. The first place to start is the MS
Access Security FAQ:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Download and read-read-read this doucment ... it is complex and can be
difficult to understand. However, if you follow the steps outlined you'll
secure your database as well as an Access database can be secured ... how
well that is is another issue, though.
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "

 

[Albert D. Kallal]

You don't need security to keep people out of the database stuff.

You can use some code to dis-able the shift key. The only other things you
need is to setup the options in tools->start-up. In the start-up you can set
all off the options you need to hide all of ms-access.

Try downloading the 3rd example at the following:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

That above example has all of the ms-access interface hidden, and NO code
was used to accomplish this.

For "YOU" to check out how this was done, then you have to exit the
application and then re-start the application and hold down the shift key
during start-up. So, try the above and see how it hides the ms-access
interface (the ONLY settings needed is in tools->start-up).

You can also grab my shift key code that will set, or un-set the above at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

The above shift key example allows you to browse to any ms-access file, and
set, or un-set the shift key code.

 

[Mark]

Hey Albert,

I cannot begin to thank you enough!!!! The link you gave
me is exactly what I need. In fact, it is an awesome
resource to have for future use. Thanks for the quick
response and the more than expected assistance!!!!!

Hope we run into each other sometime again. Have a good
one over there!!!

Mark