Access 2007 Security?

[SF]

Hi

I learnt that Access 2007 has removed the security level for the accdb file.
My Office has a plan of moving from Access 2003 to Access 2007. I am concern
how to deal with security when we upgrade our office to 2007. Could someone
advice on security in Access 2007. I have my current database (2003)
connected to SQL Server 2005 now.

SF

 

[Joan Wild]

You don't necessarily have to do anything. Access 2007 can open/use a mdb in 2003 format, as is.

You'd just modify the desktop shortcut to
"path to 2007 msaccess.exe" "path to 2003.mdb" /wrkgrp "path to 2003 mdw"

2007 can still use security in the mdb format.

--
Joan Wild
Microsoft Access MVP
: Hi
:
: I learnt that Access 2007 has removed the security level for the accdb file.
: My Office has a plan of moving from Access 2003 to Access 2007. I am concern
: how to deal with security when we upgrade our office to 2007. Could someone
: advice on security in Access 2007. I have my current database (2003)
: connected to SQL Server 2005 now.
:
: SF
:
:

 

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

then use SQL Server security.

secure views, sprocs, tables, columns; etc
(using views it is easy to implement row level security also)

-Aaron