DB opens with default system.mdw file once secured

[PaulJK]

Hello,

I have secured a database using the steps 1 to 10 within the Frequently Asked Questions About Microsoft® Access Security for Microsoft Access versions 2.0 through 2000.

I have followed the steps methodically, however when testing the security I find I can open the database using my system.mdw file! I thought importing objects to a new database whilst being a member of the Admins group would get around this problem

Are there any solutions to get around this so the database will not open with the default system.mdw file!

Thank you.

 

[dcx693]

I have followed the steps methodically, however when testing the security I find I can open the database using my system.mdw file!

OK, but what can you do in that database you opened?

If you can do just about everything, perhaps you did not password protect the Admin account, or perhaps you did not remove it from the Admins group.

 

[Len Boorman]

I normally edit the shortcut as below


"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "C:\Search Engine\Lgc.mdw" "C:\Search Engine\Lgc_Sec.mdb"


"C:\Program Files\Microsoft Office\Office\msaccess.exe" this makes sure an Access 97 application is opened with Access 97

/wrkgrp "C:\Search Engine\Lgc.mdw" This specifies the mdw file to be used

"C:\Search Engine\Lgc_Sec.mdb" This is the application

Len

 

[PaulJK]

Hi,

Thanks for your replies.

I can get into security using my logon and everything works ok. The Admin user is a member of the Users group with no permissions and has a logon password!

I am just a bit perplexed as to why I can open the system.mdw file!

I was considering importing all objects into a new database and trying security again.

I will also disable the bypass key with a password to add more security and edit the shortcut as you described.

 

[Len Boorman]

If you want to PM me with an email address I have a zip file with Security notes. Included is the FAQ but there is another document that I have found very useful. Will try to load here but in the past have had problems.

Len

PM me with an email address if you would like these notes cos the attachment failed

 

[dcx693]

When you say:

however when testing the security I find I can open the database using my system.mdw file!

do you mean that you can edit the info in the database (i.e., do things that require assigned access rights), or that you can merely open the database file?