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?.
--
Mark Gerlach

"MagicMark" <(E-Mail Removed)> wrote in message
news:34631000-C09C-443C-85F8-(E-Mail Removed)...
> 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

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/sh...ll#Post1243573

Keith Wilby wrote:
> "MagicMark" <(E-Mail Removed)> wrote in message
> news:34631000-C09C-443C-85F8-(E-Mail Removed)...
>> 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