I created 2 accdb files; Front1 and Back1 in A2010. I opened both
exclusively and set a shared-level security password in each; Front1 and
Back1 respectively.

Front1 had no objects. No tables, queries, forms, reports, or modules.

In Back1 I added a table called Junk.

I then opened Front1 and linked the table Junk in Back1. I was prompted
for a password prior to linking.

When I closed, then opened Front1, I was prompted for my password. I
entered "Front1" and I was able to view the linked table Junk. I didn't
have to enter 2 passwords; Front1 and then Back1. Just Front1.

I then saved Front1.accdb as Front2.accdb. I opened Front2 exclusively,
modified the password to Front2.

Now when I open Front1 I must enter the password Front1, opening Front2
I must enter Front2 as the password, and I am automatically linked to
table Junk in Back1. Iow I am not prompted for Back1's password. Of
course if I open Back1 by itself I must enter the password Back1.

In the above examples, is the entire database encrypted? For example,
in the Front ends that have no objects (when initially created) is the
database encrypted or is it just tables that are encrypted?