Access2007 Security (lack of)

[MagicMark]

It seems that with Access2007 MS has turned the idea of security inside-out.
I have always viewed database security as a question of whether the Database
can trust the User. The user workgroups determined what capabilities the
user had, read-only, modify, none....
Now it looks like a question of whether the User can trust the Database. In
order to prevent unauthorized users from accessing or changing data in an
Access '07, I have to either reprogram workgroup security in each database or
depend on Windows folder security. The former is a lot of work and the
latter forces me to have the front-end code in multiple folder locations to
allow some users to view data, some to update, some to add, etc...
We have dozens of databases built in Access 97/2000/2003 that this issue
will affect. Does anyone know of a way around this or of any third-party
software that will work cleanly with Access?.

 

[Keith Wilby]

In
order to prevent unauthorized users from accessing or changing data in an
Access '07, I have to either reprogram workgroup security in each database
or

I don't have A2k7 but AIUI user-level security is supported in the mdb file
format so it should just be a case of importing all objects into a new A2k7
mdb format file.

Keith.
www.keithwilby.co.uk

 

[Banana]

Indeed, you can continue to use ULS in 2007 as long you use .mdb format.
If you must use .accdb (and I'm hard pressed to give a good reason
why... maybe attachment fields but...), you have the option of using vPPC.

(watch out for broken link)
http://www.utteraccess.com/forums/showflat.php?Number=1243573&fpart=all#Post1243573