All I need is a simple password!

[NewShoes]

Hey all,

I'm running Access 2010 and have a FE/BE database that I would like to secure. I thought I could basically put a password on the BE that would stop anyone from going into the folder and opening the BE directly. However, upon reading some security info on the MS website (link below), it seems that to set a password, the database also has to be encrypted which messes with the record locking settings. To quote from MS...

"When you encrypt a database with a password, the encrypted database will use page-level locking, regardless of your application settings. This may affect the availability of data in a shared environment."

Is there anyway to just set a password on the BE so it prompts the user before opening!?!

http://office.microsoft.com/en-us/access-help/introduction-to-access-2010-security-HA010341741.aspx

Many thanks,
-NS

 

[gemma-the-husky]

can't help - to be honest, i don;t think it is so important to secure back ends

 

[SmallTime]

Hi,

You could create the BE in pre-2007 (mdb) version with a secure MDW file and use the built-in user security\permissions, don't forget to remove all permissions from 'admin' and 'user' groups top prevent users from opening the BE by d.clicking it.


SmallTime