We're running Access 2007 and sql 2000.

We're in the process of converting from Access 2003 to 2007.

We have several databases that's used by some 400 users on 250+ computers.
During the testing process we've had problems with the security settings.

We have a reg hack that will bypass the security but the hack has to be run
under each persons profile.

How can we bypass the security by computer instead of by user?

Thanks,

Paul

On Tue, 14 Jul 2009 07:58:01 -0700, pjscott
<(E-Mail Removed)> wrote:

Place the A2007 database in a "Trusted Location" (see help file)

-Tom.
Microsoft Access MVP


>We're running Access 2007 and sql 2000.
>
>We're in the process of converting from Access 2003 to 2007.
>
>We have several databases that's used by some 400 users on 250+ computers.
>During the testing process we've had problems with the security settings.
>
>We have a reg hack that will bypass the security but the hack has to be run
>under each persons profile.
>
>How can we bypass the security by computer instead of by user?
>
>Thanks,
>
>Paul