Access2007 Security (lack of)

  • Thread starter Thread starter MagicMark
  • Start date Start date
M

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?.
 
MagicMark said:
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
Click to expand...

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
 
Back
Top