Database Security

[angiew]

I am rather confused in regards to setting up security for a database. I have three separate databases that will be on our network. I have set persmissions so the users can only read and open the objects. This works fine, and I can log on under Admins with a password, but it askes me to log on for any database I open, not just when I try to open these three that I have created. I tried to run the Wizard when I first started creating the security, but got rather technical and I was not comfortable with the information it was requesting. How can I change it so the only prompts to log on are for these three databases and not others?

Thanks!

Angie

 

[desiboy]

The reason why it's asking you to log on to any database you open is because I think you have changed your workgroup file from default system.mdw to the one you created yourself.

What you should do is this. Create a shortcut on the desktop or in a folder to the secure database. In this shortcut's properties you should specify the workgroup file this particular database is supposed to use.

And change your workgroup file back to the default System.mdw if you don't want to be asked for log on for any other databases.

 

[angiew]

I never did set up a workgroup file. How do I go about setting one up?

Angie W.