Secure Database

  • Thread starter Thread starter George
  • Start date Start date
G

George

Now that I have created my database and ready to bring it to work how can I
prevent others from holding down the Shift Key on start up and altering my
program ? The program is not passowrd protected !
 
George said:
Now that I have created my database and ready to bring it to work how can
I
prevent others from holding down the Shift Key on start up and altering my
program ? The program is not passowrd protected !
Click to expand...

You can build an MDE or secure your database. Here are security options:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
 
On Sun, 27 Dec 2009 13:57:01 -0800, George

You can deploy as MDE/ADE/ACCDE so there is no VBA code to be
modified.
Holding down the Shift key and other special keys can be disabled -
search for it online or in the help file. Be sure to understand this
feature completely before you implement it; you don't want to lock
yourself out. You are keeping backups in a safe place, right?

-Tom.
Microsoft Access MVP
 
Holding down the Shift key and other special keys can be disabled
Click to expand...

....but it can also be easily re-enabled by anyone who knows just a
little bit about how it's done in the first place.
 
I did create a ACCDE
Click to expand...

Note that with ACCDB/ACCDE format, none of the citations about Jet
User-Level Security are relevant, as the ACCDB format does not
support Jet ULS.
 
They are sufficient, but as David says someone can use that same code to
set the property back.

Joan Wild
 
So based on the responses the bypass key can be disabled but none of the web
sites listed explain how to perform this task for Access 2007

Thanks
 
But only if they have dbSecWriteDef permission.
Click to expand...

You're only moving the pieces around on the chessboard. Anyone can
hack Jet ULS, and if they can do that, setting those permissions
won't have any effect.

BTW, I'd always used the code in the Access help file, and had never
since MichKa's version.

The point is, it makes it harder, but my thought is that anyone who
is trying to override the startup properties is likely not going to
have any qualms about hacking ULS.
 
So based on the responses the bypass key can be disabled but none
of the web sites listed explain how to perform this task for
Access 2007
Click to expand...

The second sub here:

http://www.mvps.org/access/general/gen0040.htm

....ought to do the trick. The first sub will work also, but you
won't get the security benefit in an ACCDB, since Jet ULS doesn't
exist for ACCDB format. You would see the same results in MDBs in
A2007.
 
Thanks - First I should mention I am somewhat of a novice, I did see this sub
and I copied it into a VBA and tried to run it and it came back wit an error
message unexpected end. What should I do with the code at this web site you
mentioned?

George
 
You certainly can reset the shiftkey in a MDE (from another database,
which is how you'd do it anyway).

Joan Wild
 
First I should mention I am somewhat of a novice, I did see this
sub and I copied it into a VBA and tried to run it and it came
back wit an error message unexpected end. What should I do with
the code at this web site you mentioned?
Click to expand...

Did you check that it compiled before you tried to run it? If so,
how did you run it? Did you provide it with appropriate arguments?
 
But not in an MDE or other compiled format.
Click to expand...

How, exactly, does MDE/ACCDE format prevent running the code in
question replacing this:

Set db = CurrentDb

....with this?

Set db = DBEngine.OpenDatabase("C:\MyMDE.mde")

Seems to me there is no way to prevent anyone from re-enabling
startup.
 
David - The web site you suggested seems to have more then one code to select
from - which is Greek to me - can you copy to here what I need and I should
be able to find my way from there.

Thanks
 
Back
Top