Database security and getting round it

[Duncan Edment]

OK, my database is now set so that it prompts each user for a password and
it works great. I have an icon in a program group, they click on it, Access
loads, prompts for password, then loads the database.

However, if the user loads Access directly, selects the "Open file" option
and navigates to the database, they can open it, without it prompting for a
password and can do anything they want in it.

My question is this: How do I prevent this happening? Is there some code I
can put in the open event of the switchboard, that will check something to
see if they have logged in correctly. If yes, then the database would
continue to load as normal. If they haven't loaded it correctly, display a
message box advising them how to open it correctly, and then quit out of
Access.

Can this be done?

Rgds

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

 

[TC]

Are you saying that you have coded your own password feature? Or are you
using the built-in "database password", or "user level security password"
features?

If you have coded your own process, give us more information, or chuck it
out & use the built-in password features.

HTH,
TC

 

[Scott McDaniel]

And, if you are using the builtin User Level Security, then you didn't
properly apply security. You MUST follow the steps outlined in the MS Access
Security FAQ exactly in order to properly secure your datbase. The fact that
you can open your database directly is an indication that you didn't do so.

Download and read-read-read the MS Access Security FAQ:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp