Shippwreck
Programmer
Hi,
I'm trying to query a remote DB with a password using SQL only. Ie no linked tables, no VBA just the SQL. I can do this for a DB without a password but can't seem to do it for one with... here's what I mean:
That works great when the DB isn't password protected, but if there's a password on the DB it gives me the "Not a valid password" error.
Any ideas on how to incorporate the password into the query?
Cheers
"Google is god...of the internet" - Me
I'm trying to query a remote DB with a password using SQL only. Ie no linked tables, no VBA just the SQL. I can do this for a DB without a password but can't seem to do it for one with... here's what I mean:
Code:
SELECT * FROM table1 IN "C:\remote_db.mdb"
That works great when the DB isn't password protected, but if there's a password on the DB it gives me the "Not a valid password" error.
Any ideas on how to incorporate the password into the query?
Cheers
"Google is god...of the internet" - Me