Problems with user security

[jimoharry]

Hey, when i set up user security at home on a database and save this database to my USB memory stick, i then take this memory stick to be open on another different computer at the internet cafe. However, when i open the database on another different computer there is no prompt for log in user names and passwords. This is not what i want.

Why is this so?

Thanks for the help

 

[gemma-the-husky]

because you need to copy the security rights file (the .mdw file) as well, and then at work you need to join the workgroup before running the dbs.

 

[jimoharry]

Ok

Re: Gemma the Husky

Yeah but how do i join a workgroup before running the database?
Don't you run the database then join the workgroup?

 

[gemma-the-husky]

i'm more used to security with A97. In A97 the workgroup security is outside Access, but in later versions the workgroup administrator is within the Access programme.

I think therefore you probably need to open later versions of Access, then run tools/security/workgroup administrator to join the workgroup, and only then will you be able to open the secured file - which means the .mdw file still has to be available to your computer

I don't think its embedded in the Access app.

If this isnt right can anyone else help?

 

[apr pillai]

problem with user security

Try the link http://msaccessblog.blogspot.com/2006/11/microsoft-access-security.html

 

[Len Boorman]

My suspicion is that the security has not been set up correctly to start with.

Once secured it should prompt for logon/password.

If mdw file not available for whatever reason then you should get a failure

What version of Access ?.

I have some notes if you send me a PM with an email address to which I can send a couple of documents.

These are basically 97 and 2000 but believe most aspects apply

Len

 

[The_Doc_Man]

1. The current workgroup is a REGISTRY entry, not an Access datum, so you must join the workgroup EVERY TIME YOU CHANGE COMPUTERS!

2. You can keep the workgroup file on the stick, but since different machines call a stick drive D, E, F, G, or some higher letter, you might have to manually join each time. If the letter were always the same, you could do this by building an ICON as a shortcut to the database and use the command line option that defines the workgroup. See Access Help for Command Line Options and the /WKGRP option to see how this is done.

3. I concur with Len. The behavior you describe suggests you only did half of the job in securing the database. Search this forum for Workgroup Security threads, of which there must be hundreds.