Using Access 2002 version.

I have a split database.  When the user closes their frontend, the code
checks to see if a backup is needed, and if so, prompts the user to backup
the database.

The code calls a function CompactToNewDatabase which finds the backend db
and compacts the backend to a new db in a different directory on a different
drive on our server.   Actually, the code works fine.

I put a password on the backend database.  I then opened the frontend and
set a password on the frontend db.  Then I used the table link manager and
successfully entered the password to the backend db and linked the tables.

However, now when I close the frontend db and the user is prompted to backup
the database, the user is prompted again to enter the password for the
backend db.  I am not sure why they are being prompted to enter a
password???  Is this a normal response from Access?  Is there something that
I am doing wrong.  Sure would appreciated any help.

Thanks in advance