Secure Database

[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 !

 

[Arvin Meyer [MVP]]

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 !

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

 

[Tom van Stiphout]

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

 

[George]

Arvin - I did create a ACCDE but you can still open it by holding down the
shift Key.

I will try the other items you listed.

This web site has a program to disbale the Shift Key but it doesn't work on
Access 2007 - is there a new version around

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Thanks

 

[Arvin Meyer [MVP]]

I haven't tried this code in Access 2007, but it should work:

http://www.mvps.org/access/general/gen0040.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[David W. Fenton]

Holding down the Shift key and other special keys can be disabled

....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.

 

[David W. Fenton]

I did create a ACCDE

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.

 

[Tom van Stiphout]

On 28 Dec 2009 21:33:10 GMT, "David W. Fenton"

Really? In what way are these steps:
http://www.mvps.org/access/general/gen0040.htm
insufficient?

-Tom.

 

[Joan Wild]

They are sufficient, but as David says someone can use that same code to
set the property back.

Joan Wild

 

[Douglas J. Steele]

But only if they have dbSecWriteDef permission.

 

[George]

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

 

[David W. Fenton]

But only if they have dbSecWriteDef permission.

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.

 

[David W. Fenton]

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

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.

 

[George]

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

 

[Tom van Stiphout]

But not in an MDE or other compiled format.

-Tom.
Microsoft Access MVP

 

[Joan Wild]

George said his database wasn't secured.

Joan Wild

 

[Joan Wild]

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

Joan Wild

 

[David W. Fenton]

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?

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?

 

[David W. Fenton]

But not in an MDE or other compiled format.

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.

 

[George]

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