basic password/encryption questions for 2007

[salmonella]

With a split database:
1) what is the downside of not encrypting the FE and only the BE?
2) when using an encrypted BE, does the whole Be become decrypted at logon,
or is it only the data flowing in and out of it. In other words, is the Be
vulnerable/decrypted if it is in use?

thanks,

 

[John W. Vinson]

With a split database:
1) what is the downside of not encrypting the FE and only the BE?

It's only an issue if you worry about someone else seeing your VBA code or
form/report structure. No data will be compromised.

2) when using an encrypted BE, does the whole Be become decrypted at logon,
or is it only the data flowing in and out of it. In other words, is the Be
vulnerable/decrypted if it is in use?

The backend does not become encrypted; the user with a valid password will be
able to read it, but nobody else will.

 

[John W. Vinson]

The backend does not become encrypted; the user with a valid password will be
able to read it, but nobody else will.
--

Sorry... the backend does not become *un*encrypted.