Unanswered: Select query from table in external DB
I'm trying to make a select query that access a different MS-Access database, but my problem is that the second database is protected with a password and I still haven't found the sintaxis to include the code.
This is the sql query I have made:
Select * FROM C:\DataBasesDir\DataBase2.Table
When I try to execute this query, it returns me an error msg telling me that it's an incorrect password (which is logical, 'cause I'm not passing any)
Could somebody help me with this, please?