Can i link to tables in an encrypted database?

[Mike]

Hi. I've created an Access 2007 database, and have split it into a back-end
of tables and a front-end of forms/reports. I want to encrypt the back-end
database containing tables. But when I encrypt it, I can't link to & connect
to it from the front-end. I've tried re-linking the front-end to the
back-end, but I keep getting the error stating "not a valid passwod". Its
not asking me for a password.

How can I link to tables which exist in an encrypted database?

Thanks!

 

[Dirk Goldgar]

Hi. I've created an Access 2007 database, and have split it into a
back-end
of tables and a front-end of forms/reports. I want to encrypt the
back-end
database containing tables. But when I encrypt it, I can't link to &
connect
to it from the front-end. I've tried re-linking the front-end to the
back-end, but I keep getting the error stating "not a valid passwod". Its
not asking me for a password.

How can I link to tables which exist in an encrypted database?

Would this be Access 2007, by any chance? If I recall correctly, you can't
use the Linked Table Manager to relink the tables. You can delete the
linked tables and then use the dialog from the External Data tab to recreate
the links -- it will prompt you for the database password. Or you can do
the relinking yourself, in code, in which case you must supply the password
as part of the connect string; e.g.,

tdf.Connect = "MS Access;PWD=yourpassword;DATABASE=your path to the
backend.accdb"

I believe that works.