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.

Does anyone know how this can be achieved?

Many thanks,