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.