I have several clients that are using Access 2000 and 2003 databases that
utilize user level security. These clients want to convert the databases to
2007. I read in a previous post that you can still use user level security
in 2007 if the *.mdb file is not converted to *.aacdb. Is it possible to
convert the file to *.aacdb and then still use the security? Has there been
another feature created in 2007 which allows you to control which user
permission in database objects? User level security is extremely helpful, I
can't imagine why it would be illiminated from this version. Can someone
enlighten me?

"Williams" <(E-Mail Removed)> wrote in message news:EDC96339-7F00-4BA5-9850-(E-Mail Removed)...
:I have several clients that are using Access 2000 and 2003 databases that
: utilize user level security. These clients want to convert the databases to
: 2007. I read in a previous post that you can still use user level security
: in 2007 if the *.mdb file is not converted to *.aacdb. Is it possible to
: convert the file to *.aacdb and then still use the security?
No

:Has there been
: another feature created in 2007 which allows you to control which user
: permission in database objects?

No

:User level security is extremely helpful, I
: can't imagine why it would be illiminated from this version. Can someone
: enlighten me?

You have to roll your own if you want this type of control in accdb.

--
Joan Wild
Microsoft Access MVP

Does that mean you need VB code for each object?

"Joan Wild" wrote:

> "Williams" <(E-Mail Removed)> wrote in message news:EDC96339-7F00-4BA5-9850-(E-Mail Removed)...
> :I have several clients that are using Access 2000 and 2003 databases that
> : utilize user level security. These clients want to convert the databases to
> : 2007. I read in a previous post that you can still use user level security
> : in 2007 if the *.mdb file is not converted to *.aacdb. Is it possible to
> : convert the file to *.aacdb and then still use the security?
> No
>
> :Has there been
> : another feature created in 2007 which allows you to control which user
> : permission in database objects?
>
> No
>
> :User level security is extremely helpful, I
> : can't imagine why it would be illiminated from this version. Can someone
> : enlighten me?
>
> You have to roll your own if you want this type of control in accdb.
>
> --
> Joan Wild
> Microsoft Access MVP
>

yes, SQL Server security works just perfectly.

-Aaron




On Jun 26, 8:43*am, Williams <Willi...@discussions.microsoft.com>
wrote:
> I have several clients that are using Access 2000 and 2003 databases that
> utilize user level security. *These clients want to convert the databases to
> 2007. *I read in a previous post that you can still use user level security
> in 2007 if the *.mdb file is not converted to *.aacdb. *Is it possible to
> convert the file to *.aacdb and then still use the security? *Has therebeen
> another feature created in 2007 which allows you to control which user
> permission in database objects? *User level security is extremely helpful, I
> can't imagine why it would be illiminated from this version. *Can someone
> enlighten me?