[AccessD] Password protect 2007 db

[Charlotte Foust]

In 2010 and later you can use data macros on the tables themselves  stamp
each record with the user name and date a record was added or updated. I
include a user table and a routine to make sure the user is in that user
table.

In 2007 you're still stuck with workgroup security.

Charlotte Foust
(916) 206-4336
On Jan 29, 2016 10:59 AM, "FW Salato Center" <Salato at ky.gov> wrote:

>
> https://support.office.com/en-ie/article/Encrypt-a-database-by-using-a-database-password-fe1cc5fe-f9a5-4784-b090-fdb2673457ab#bm2
>
> I need to password protect an Access 2007 split database, which will have
> a handful of people accessing it regularly. I don't need serious protection
> as I'm not worried about someone stealing info. It'll be on a server with
> company access and I just need to stop agency-wide employees from
> accidentally opening it and doing damage. I'll have regular backups and
> nothing's confidential. I'm just trying to avoid unintentional access.
>
> This seems good enough to me.
>
> Thoughts?
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>