Encrypted backend database

[PaulA]

Hi, all -

I've converted an older mdb database to Access 2010. In doing so, I'm creating user-level security as much as possible.

Question: If my BE database is encrypted and I link it to the FE database, entering the password, will that link hold up for if the FE is copied and put on different user hard-drives? The BE is stored on a shared server.

May be a silly question but this is an offsite project and anticipating possible problems in advance will be helpful.

Thanks.

 

[llkhoutx]

Yes, provided the path of the BE is the same. Note that an encrypted BE is significantly slower for multiple users. A non-encrypted BE utilizes row locking, while encrypted BEs utilize page locking.

 

[CJ_London]

non-encrypted BE utilizes row locking, while encrypted BEs utilize page locking.

new one on me - where have you heard/read that?

 

[llkhoutx]

I stumbled onto it researching "securing a multi-user Access BE."