Password Protecting

[JReagan]

Is there a way of Password protecting an Access 2007 database automatically through VBA? This is going to sound funny but I am pretty sure if this will work then I might have it fairly secure.
I'm looking for code that will diable the password on open and set the password on close. Is this possible?

JB

 

[DCrake]

In order to disable the pasword on open you have to actually open it first so that the code can be executed. So that being the case, No you can't. Anyway Access will only let you remove the passwork if you open it in Exclusive mode.

Then again if you ever managed it what would be the point of it. When would the password come into force?

 

[JReagan]

A password would protect the objects from being linked to. That is the purpose I am trying to get here. It looks like I'm just at a dead end and Access is really limited as far as security is concerned.

 

[DCrake]

It is only because I have read the various postings you have made on a very similar subject that I know the background but you cannot link to a password protected database unless you know the password. Even so if you get access to the front end it is very easy to find out what the back end mdb password is if you know where to look.

 

[JReagan]

I'm pretty sure that the Users are savy enough to look at the back end by linking or importing, and also viewing system objects. I'm pretty confident they wouldn't know where to look as far as passwords are concerned though.

 

[DCrake]

Let me ask you this.... Do you know where to find the password of a database that you have linked to?

 

[JReagan]

You can find the password through some of the code, but you can also lock the code out too.

 

[DCrake]

Actually if you open up the MySysObjects table and look in there at the Database field. The path to the linked table is stored there. And if the back end is password protected it has the password there. Something like Password="FRED".