Link external Access database

[Guest]

I created two databases, one works as an interface the other works as a data
storage. I linked interface one to a table in storage one. I secured the
interface one and also secured the data storage one with database password.

Every time I access the table in storage database from interface database, I
have to enter the password of storage database.

Is there any way I can use VBA code to hard code the password, so I do not
need to enter the password every time when I access the table of storage
database from interface database.

 

[Joan Wild]

I created two databases, one works as an interface the other works as a
data
storage. I linked interface one to a table in storage one. I secured the
interface one and also secured the data storage one with database
password.

Every time I access the table in storage database from interface database,
I
have to enter the password of storage database.

Is there any way I can use VBA code to hard code the password, so I do not
need to enter the password every time when I access the table of storage
database from interface database.

Delete the table links in the frontend (interface one). Then recreate them.
You'll be prompted for the backend password, but this time it will be stored
with the links and you won't be prompted again.