Re: User level security in Access 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Access 2007 supports user level security as long as the db file stays in the
same file format as previous versions for Jet, not the new file format for
ACE. The new ACE engine, which uses the accdb, accde, accdr and accdt file
extensions, doesn't support user level security.

Chris
Microsoft MVP


Acie wrote:
I'm in the process of converting Access 2002 applications that use MDW files
to Access 2007, and I have a question.

1. I generally provide the user with a shortcut that contains the .mdw file,
which restricts which uses can access the app and edit or delete queries,
reports, etc. in Access 2002.

Apparently, Access 2007 does not support user level security anymore. Does
this mean I can no longer use mdw files and implement user level security by
login id ?

If not, how do I go about implementing user level security using Access 2007 ?

I did try to convert a db with mdw files into .accdb file. The app did
validate the users correctly, but it did not restrict users from deleteing
queiries, etc. I also noticed the missing user security menus.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • User level security in Access 2007
    ... I'm in the process of converting Access 2002 applications that use MDW files ... Access 2007 does not support user level security anymore. ... The app did ... but it did not restrict users from deleteing ...
    (microsoft.public.access.security)
  • User Level Security & Access 2007
    ... I need to convert many MS Access 2003 applications to MS Access 2007. ... problem is that all these applications uses User Level Security and it needs ... can preserve User Level Security by migrating the database whith the ".mdb" ... new file format so that we would be ready to upgrade whenever the ...
    (microsoft.public.access.security)
  • Access 2003 user level security
    ... I've got an XP2002 db that I secured via user level security. ... "you do not have open/run priveleges on form" ... I've had those same 2003 users log into the db on a 2002 machine and ... Is there a file format issue here? ...
    (comp.databases.ms-access)
  • Re: Access 2003: Thinking about going multiuser with user security,...
    ... you're going to want some modules in the app that run on startup. ... This is especially important with regard to disabling the bypass key. ... Read through some tutorials about User Level Security and walk through the ULS Wizard a bunch of times. ...
    (comp.databases.ms-access)
  • Re: authentication Mode
    ... Consider using an Application Role rather than user level security. ... Most good judgment comes from experience. ... This app must allow for two login scenarios other than the usual one ... using a machine running under a different users login. ...
    (microsoft.public.sqlserver.security)