Trouble with securing database

[stevievee]

Hi,

I have tried to secure my database, using simple, one level security.

When I try to open the database via an Excel form, in a Jet workspace, it says that system32.mdw is not present, which is correct.

The main problem is that this database will be accessed by many people, all via my Excel VBA application. Have I done something wrong with the security, and can I implement it in a way that this mdw file is not required.


Thanks in advance.

 

[The_Doc_Man]

can I implement it in a way that this mdw file is not required

Not and keep it simple, too.

You might wish to take the approach of creating a .mdw file in the same folder as the shared database. Then include a "/wrkgrp" option in the shortcut or command line that leads to the database. Don't know exactly how you would do this from Excel, but that /wrkgrp option is the only way to force a specific .mdw file to be used, and you DO really need one.

But be warned that as it goes, the type of security you have defined is almost the same as no security at all.

 

[Pat Hartman]

Here's just a small selection of the articles on security available from the Microsoft knowledge base. I know you're working with Excel but the Word article may give you some idea on how to access the secured db from Excel.

ACC2000: How to Use a Secured Database in Word Mail Merge
http://support.microsoft.com/default.aspx?scid=kb;en-us;208933
ACC2000: Understanding the Role of Workgroup Information Files in Access Security
http://support.microsoft.com/default.aspx?scid=kb;en-us;305541
ACC2000: How to Use the OpenDatabase Method to Open Password-Protected Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;209953