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

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
"SF" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
: 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
:
:

then use SQL Server security.

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

-Aaron




On Jun 25, 8:40*pm, "SF" <x...@yahoo.com> wrote:
> 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