D
Duane
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
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