User-Level Security Access

  • Thread starter Thread starter Lindsay
  • Start date Start date
L

Lindsay

I have created a database that is housed on a server, and I am the
administrator. I created user-level access for all of the users. When
we began to use the database the users joined the workgroup and were
able to login. Now everytime a user logs on from their own computer
they get an error message "not a valid username or password". I have
reset the passwords from my computer, and I am able to log onto their
accounts from my computer, but they are still not able to log on from
their own computers. Is this a server problem or is this a database
problem??? HELP!
 
They should be accessing your file using a shortcut tat includes the
workgroup file...

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"
 
Go to Tools, Security, User and Group Permissions, and then select the
object (table) that you want and the user group for your users and uncheck
the "Insert Data" permission.

This assumes that you have already properly implemented user-level security
to secure your database and have created the appropriate users and groups.
 
I have created a database that is housed on a server, and I am the
administrator. I created user-level access for all of the users. When
we began to use the database the users joined the workgroup and were
able to login. Now everytime a user logs on from their own computer
they get an error message "not a valid username or password". I have
reset the passwords from my computer, and I am able to log onto their
accounts from my computer, but they are still not able to log on from
their own computers. Is this a server problem or is this a database
problem??? HELP!
Click to expand...

I'd suggest using the

/wrkgrp E:/path/filename.mdw

switch in a Shortcut to open the database, rather than just having the
users open the database directly. They must be Joined to the workgroup
using the custom workgroup file for this database; this command line
switch enables them to do so pretty much invisibly.

John W. Vinson[MVP]
 
Oops - Disregard. I was answering a different question. LOL

How do you do that? Just build your shortcut using the path with the
parameters I included...

"Full path to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your WIF.mdw"
 
Back
Top