Access 2007 Security - Conversion

[Williams]

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?

 

[Joan Wild]

: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.

 

[Williams]

Does that mean you need VB code for each object?

 

[a a r o n _ k e m p f]

yes, SQL Server security works just perfectly.

-Aaron