MDE in Access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KarenH - 24 Oct 2005 15:11 GMT

I created an MDE from an Access 2000 mdb. The purpose of this is to protect
the database from other users' attempts to make or modify queries, code,
design. However, I see that I am able to get to the database and do all of
that by holding down the shift key. If this is the case, then what is the
purpose of the MDE? Also, I have always thought that if you make changes to
an mdb, you need to recreate the corresponding MDE -- this doesn't seem to be
the case, since I can make changes and save them with my current MDE without
making a new one. Shouldn't the MDE disallow these things?

Reply to this Message

Alex Dybenko - 24 Oct 2005 20:11 GMT

Hi,
purpose of MDE - disallow make changes to form/report design and VBA code.
tables/queries you can design in MDE.

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>I created an MDE from an Access 2000 mdb. The purpose of this is to
>protect
[quoted text clipped - 10 lines]
> without
> making a new one. Shouldn't the MDE disallow these things?

Reply to this Message

DGionet - 25 Oct 2005 18:52 GMT

You can disable the Shift Key bypass in Access via code:

I have a routine that includes the following (this can only be done via
code, there are no options in the Tools/Options to toggle this):

If db.Properties("AllowBypassKey") = True Then
db.Properties("AllowBypassKey") = False
MsgBox ("The operation was successful. Bypass is not allowed.")
Else
db.Properties("AllowBypassKey") = True
MsgBox ("The operation was successful. Bypass is allowed")
End If

you just have to be careful because if you have that and you disable F11 to
get to the routines, you could lock yourself out.

The good thing is that you can use the db.properties from outside the
database by using another db with and have:
Set db = DBEngine.OpenDatabase(databasePath)
before the other lines above.

As the other post points out, MDE only prevents viewing/modifying code, but
not queries, etc.

David

> I created an MDE from an Access 2000 mdb. The purpose of this is to protect
> the database from other users' attempts to make or modify queries, code,
[quoted text clipped - 4 lines]
> the case, since I can make changes and save them with my current MDE without
> making a new one. Shouldn't the MDE disallow these things?

Reply to this Message