Access 2K security problem.

[Blitz]

I was just playing with setting up security for my database, I followed the instructions that are in the FAQ but now my computer is the only one that requires a password to get into the database. All the other computers can still access the database without requiring a password. Also my computer requires a password not only for the database I set security up on but also my other database that I did not want secured. So basically Im very confused as to how to make access security work so if any of you have and ideas id appreciate it. thanks.

 

[HIM]

You need to activate the use of the workgroupfile on those computers as well.<br>This has shown to be the most irritating part of this. Why? Because you need to do it for every user on every machine (at least on an NT). If you have an NT environment, I can show you how to get around this at startup through the logon script.

 

[Blitz]

Well Im a little confused as to what the point is of securing a database if any computer that doesnt have the workgroup file setup can open it. Even if I set the workgroup file up on every workstation someone could still copy the database and open it from their home computer that doesnt have the workgroup file setup. <br><br>Well I may just not worry about it, I figure if I disable the shift key that should be good enough to keep users from going in a doing things they arent supposed to.

 

[GDGarth]

I've got several databases running on a shared drive at work.&nbsp;&nbsp;To secure them, I follow these steps:<br><br>1.&nbsp;&nbsp;Create a new workgroup information file.&nbsp;&nbsp;There's a program to create this in the directory that holds your access program files.<br><br>2.&nbsp;&nbsp;Join the new workgroup. (Not System.mdw)<br><br>3.&nbsp;&nbsp;Create a new user name, and put that user in the &quot;Admins&quot; group.<br><br>4.&nbsp;&nbsp;Remove the default &quot;Admin&quot; user from the &quot;Admins&quot; group (leave &quot;Admin&quot; in the &quot;Users&quot; group).&nbsp;&nbsp;This is the default user for those who don't belong to your workgroup. <br><br>5.&nbsp;&nbsp;Run the User-Level Security Wizard to create a secure copy of your database.&nbsp;&nbsp;<br><br>6.&nbsp;&nbsp;Look under &quot;Tools - Security&quot; to set permisions for various objects for each user and/or group.<br><br>I should point out, I've done this in Access 97, but I think it's the same in 2000.<br><br>I don't think this security is easy to defeat.<br><br>Hope that helps<br><br>

 

[pfenton]

Does what you've done work in Access 97 on an NT Server for a database that is constantly being up-dated?<br>I'm havin terrible after following those steps from an earlier thread - in that only one person can open the d/b at a time and I cant open the User / Groups Accounts section to make changes. The options are shaded so they can't be altered

 

[pfenton]

Does what you've done work in Access 97 on an NT Server for a database that is constantly being up-dated?<br>I'm havin terrible trouble after following those steps from an earlier thread - in that only one person can open the d/b at a time and I cant open the User / Groups Accounts section to make changes. The options are shaded so they can't be altered

 

[GDGarth]

I'm not sure what your problem is, but it sounds like you aren't logged on as an &quot;Admin&quot; user - you don't have permission to do what you're trying to do.&nbsp;&nbsp;It's possible you may not be listed as the Owner of the database (or object).<br><br>Also, check to make sure that you don't have a shortcut to the database that opens it in exclusive mode.&nbsp;&nbsp;That would stop someone else from opening it up.<br><br>I've had a little trouble with Linked files - only one person at a time can access them in some cases.<br><br>