File security

[Phil Davy]

Dear all

All I want to do is protect a particular file to make it
read-only for all users apart from me.

However when I use the wizard, I end up protecting the
actual database so that i have to use a login and
password for every single file i go in to, not just a
specific file.

I can't believe this is the only option available via the
wizard: can someone please advise me where I'm going
wrong?

cheers
Phil

 

[Rick Brandt]

Dear all

All I want to do is protect a particular file to make it
read-only for all users apart from me.

However when I use the wizard, I end up protecting the
actual database so that i have to use a login and
password for every single file i go in to, not just a
specific file.

I can't believe this is the only option available via the
wizard: can someone please advise me where I'm going
wrong?

You have created a different MDW file to secure your app and you have also
made that MDW your default. All you have to do is make the standard
"System.MDW" your default workgroup again using the Workgroup Administrator
tool. That will stop the prompting.

Then you create a custom shortcut to open your secure file that specifies
the secure MDW file as a command line argument. That causes Access to use
the secure MDW for that session only without affecting your default
workgroup setting. The syntax is roughly...

"Path to MSAccess.exe" /wrkgrp "path to alternate MDW file" "Path to MDB"

But... after you set your default workgroup back to System.MDW and before
you create the custom shortcut, try to open your secure file. You should
NOT be able to. However; if you are like 99% of those using security for
the first time you will likely find that you can get right in indicating
that you didn't apply security properly.