Can I prevent unauthorized access to DB?

[pduncan]

If I make a “user log on” form active at startup, require users to log on with username and password, and hide the database window this helps keep unwanted people getting “inside” the database. However, if they hold the shift key while opening the database, it circumvents all that. Is there anyway to prevent the shift key method of opening a database?


PDUNCAN - MEMPHIS, TN

“Friends help you hide. Real friends help you hide bodies.”

 

[LarryDeLaruelle]

PDuncan:

Two methods.

The first is to create an MDE file which is a compiled version of the mdb.

The second is to disable the shift key shortcut. Check out the faqs on this site, I believe there are a couple of ways shown on how to disable the shift key.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[DJS2]

Look up "AllowBypassKey Property" in Access help. This contains the answer and it works.

 

[RickSpr]

It also depends on what you mean by "getting into" your database. If you want to prevent users from being able to import objects from your database to a blank database they've made, or from linking to your tables from their own databases, neither of the above techniques will help.

To prevent these actions, you would either have to give your database a database password, or implement Access user-level security. A database password is easy to implement, but either adds another interaction or will be exposed to prying users. User-level security would be more secure, but takes more work to implement.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein