user level security in 2003 not working in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

i have configured user level security in access 2003. when the db is opened
with 2000, xp, or 2003 the user is prompted for username/password. OR IF
THEY HAVEN'T JOINED WORKGROUP they receive an access denied error.

HOWEVER, if i open the db with access 2007 it doesn't present an access
denied error it simply granted user full access. pretty insecure. How do I
remedy this and what is the issue? Why doesn't access 2007 present same deny
error as other versions do that are not part of workgroup?

Thank you.
 
Hi.
OR IF
THEY HAVEN'T JOINED WORKGROUP they receive an access denied error.
Click to expand...

"Access denied" is a Windows security permissions error, not an Access
User-Level Security permissions error. If the database is properly secured
and the user tries to open it while joined to a different workgroup, the
error message should be "You do not have the necessary permissions to use
the '<DB path and file name>' object. Have your system administrator or the
person who created this object establish the appropriate permissions for
you."
HOWEVER, if i open the db with access 2007 it doesn't present an access
denied error it simply granted user full access.
Click to expand...

That means either the MDB database file has already been converted to ACCDB
format (very doubtful, since presumably earlier versions can still open this
file), or else the database is not secure because one or more steps were
missed when securing the database. Please see the following Web page for
the Security FAQ:

http://support.microsoft.com/?id=207793

Study it and practice a few times on a copy of your database before
implementing it on the production version.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Back
Top