Unanswered: Using transferdatabase to link to a password protected MDB file
I have MS Access apps set up with a standard front end MDE file (containing everything but tables) and back end MDB file (containing tables only and with a database password).
Currently the front end file has links to the tables in the MDB file - the password is "Remembered" so that the front end app can access the data without the user having direct access to the tables.
I want these links to be created at run time for security reasons. I have tried to do this with Transferdatabase but I can't seem to define a database password so it asks the user when they open the app.