Unanswered: trying to link table, getting "not a valid password" error
I have two split databases, call them db1 and db2. I am trying to link one of the tables in db1's back end to db2's front end.
db1 is password-protected. When I'm in the db2 front end, and I use External Data->Access->Link, I get prompted for db1's password. When I enter the password, I get a "Not a valid password" error. I know the password is correct because I can use it to open db1's front and back ends directly.
So, how do I link to a table in another database's password-protected back end?