[AccessD] Password protect 2007 db

[Stuart McLachlan]

That's depreciated, to say nothing of it being a royal PITA :(

A locked down FE with a simple login form on startup is all that's needed in this situation.


For the BE, include a Autoexec macro which just closes the file when it is opened and make 
all the tables Hidden in case someon holds down the shift key when opening it.



On 29 Jan 2016 at 16:20, Robert wrote:

> Can you use the built Workgroup security?
> 
> WBR
> Robert
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of FW Salato Center Sent: Friday, January 29, 2016 1:58 PM To: Access
> Developers discussion and problem solving Subject: [AccessD] Password
> protect 2007 db
> 
> https://support.office.com/en-ie/article/Encrypt-a-database-by-using-a
> -datab ase-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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>