Security - User Login Box If Used On A Network Drive 2

[ps32208]

I have set up a couple of different user accounts with varying levels of security to my db. So the login box appears on startup and works fine when I open the db from my pc, but if i save it to the network drive the login box does not appear and anyone can access.

I believe this is related to the workgroup information file but have not had any success in sorting the problem.

What do I have to do so that the login box appears and therefore my security is active on the db when the db is saved and run from a network drive?

Many thanks,
Pete.

 

[PHV]

You have to remove all rights to user admin, put the MDW on the network and create a shortcut to msaccess with proper command line switches (at least /wrkgrp):

http://support.microsoft.com/default.aspx?scid=kb;en-us;209207

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bob44TheCat]

Hi Pete,
Not sure how much you have done so far from your post, or which version you're on (though the principles are pretty much the same across most versions, there are some differences), to start I'd recommend reading

http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

and

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Basically, you need to create a new workgroup information file (wif) on the network, create the db and set up its security while joined to that wif, rejoin to the default (system) wif, then set up a shortcut for users to join to your new wif just for the session when they are using that db. There's a lot more to it than that, but read the links above and it will start to come clear.

Hope this helps,

Bob.

PS - Just seen that PHV got in before me - still worth reading Jack MacDonald's paper, though!