Access Security

[BellKev]

Hello,

I have an access database in Access 2000. I have used the security wizard to secure this database. Now when other people go to try and use the database they are told they don't have the proper permissions. Any suggestions on how to fix this? They don't even get asked to enter a username or password.

 

[psemianonymous]

First, I don't know exactly what the security wizard is doing, but you might be interested in my answer to another similar question: thread181-792579 - read that after I finish here.

You should be using a custom workgroup file. This is a file with the .MDW extension. If you are using the default MDW file, you will have to start over (so go and look at the other guy's thread). If you have a custom MDW file, good.

Step two is to create a shortcut file that temporarily 'joins' the workgroup file. From my FAQ:

4. SHORTCUTS! - The proper way to open a database using Access/JET security - Use the command-line "/wrkgrp" parameter to specify the workgroup you will use for your secured database. This will most always involve the creation of a custom shortcut. An example of the shortcut's "Target" line is:
[tt]"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\atemp\dev\rq_fe.mdb" /wrkgrp "C:\atemp\dev\icg.mdw" [/tt]

This would open the "rq_fe.MDB" file using my custom "icg.mdw" workgroup file.

If you are in a multi-user environment, you should store the workgroup file in the same directory as your database backend. This means the network drive.




You just give everyone a shortcut on their desktop, and tell them to get into the database via the shortcut. If you've set up security right, they won't be able to get in any other way.


Pete

 

[BellKev]

Thank I will check out that thread. The only way to make this work (I am using it on a network and stroing everything on a network drive) is to create the shortcut? I'm only concerned because there are alot of people who could potentially use this and they are not very close together. There is no way to associate the Database with the WIF ??

 

[psemianonymous]

Unfortunately, no. Again, I agree that Access security is unintuitive in many respects. You cannot associate the database with a specific workgroup.


You can trick your users by renaming the database and putting a dummy 'logon' database that they can double-click on. In this logon database, you can then just open the real database very simply:

[tt]
'assume you have a network-stored shortcut as well as
'shortcuts on their desktops

Shell "YourShortcut.LNK"
DoCmd.Quit acQuitSaveNone
[/tt]

 

[BellKev]

Thanks for the help. I have setup a shortcut on the network location by which everyone else can copy that shortcut to their desktop and it works !! Thanks for the help