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" wrote in message news:EDC96339-7F00-4BA5-9850-49D8A551CBD4@microsoft.com... :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" wrote in message news:EDC96339-7F00-4BA5-9850-49D8A551CBD4@microsoft.com... > :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 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 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?
