I have a brand new database that is in Access 2007. Upon reading I have
learned that this version of Access does not have user level security. Anyone
know why or how to get around this oh so complex problem?

WHEN TRYING TO SAVE AS MDB I GO TO OFFICE BUTTON SAVE AS BUT IT"S ONLY
LETTING ME SAVE THE DOC IN THE DATABASE NOT THE ACTUAL DATABASE ITSELF.


"yorkielover02" wrote:

> I have a brand new database that is in Access 2007. Upon reading I have
> learned that this version of Access does not have user level security. Anyone
> know why or how to get around this oh so complex problem?

"yorkielover02" <(E-Mail Removed)> wrote in message
news:1D75C9F6-56E4-4210-8CE2-(E-Mail Removed)...
>I have a brand new database that is in Access 2007. Upon reading I have
> learned that this version of Access does not have user level security.
> Anyone
> know why or how to get around this oh so complex problem?

User level security is supported in access 2007 if you use the mdb format in
place of the accDB format.

so, if you have an application that was developed before 2007, you can use
that application in 2007, and you can use ULS if you want. Access 2007 will
present the workgroup options in the ribbon if you use a mdb file.

if you created a accDB file, and use the office button and use save-as
option to covert the accDB to a mdb file (at which point you be able to use
and implement user level security).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

"Albert D. Kallal" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> so, if you have an application that was developed before 2007, you
> can use that application in 2007, and you can use ULS if you want.
> Access 2007 will present the workgroup options in the ribbon if
> you use a mdb file.

It doesn't have to be developed in a previous version of Access --
MDB is a native A2007 format, and there is a specific A2007 MDB
format, in fact.

The restriction is not in A2007, nor in the ACE. It's in the ACCDB
file format.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/