I am trying to make a linked query, very similar to a linked table, in Access 2010. I have built a query in one database where the source database is another database. This allows me to select all from the query in the other database (SQL shown below.) The only problem is the other database is encrypted with a password, so when I run the query it displays the error message, "Not a valid password."
FROM qry_Report IN 'Location of Database.Database'
Given your password protected database is in
SELECT * FROM yourTable IN '' [MS Access;PWD=yourPassword;DATABASE=C:\Database\myDatabase.accdb]
Tested with two .accdbs (Access 2010) and it surprisingly runs kind of fast.