I have code in a hidden form that opens upon startup of a users front-end Access DB. That code looks for the appropriate linked tables. If they are not there, a dialog box lets them know they need to select the "Back End" data and an explorer window opens. The user navigates for, locates, and double-clicks the appropriate Back End DB. No problems with this code for years. Now, I am linking to a third party app DB from a custom front-end I developed. Their DB is pwd protected and I have the pwd (legally, of course). When the following code runs, I am prompted for the DB password. I enter the password and click "OK", but the table never links. When I unset the DB Pwd on the Back End, the code runs fine. I've tried ODBC, but, of course, Access doesn't like to link to Access through ODBC (Runtime 3423). Any thoughts? I'm sure I need to elaborate on my code with Pwd-protected DB.
DoCmd.TransferDatabase acLink, "Microsoft Access", tableName, acTable, "Accounts", "Accounts", False
tableName is a defined variable, just so you know.