Querying Password Protected Remote Access DB Using SQL Only

[Shippwreck]

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:

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

http://www.simpleits.co.uk

http://www.tazforum.thetazzone.com

"Google is god...of the internet" - Me

 

[PWise]

perhaps


SELECT * FROM table1 IN "C:\remote_db.mdb /pwd password

 

[Shippwreck]

Nope, that doesn't work any other suggestions guys?

Surely there must be a way of passing the password through... I know MS can do some silly stuff... but surely this would be a rather large oversite?

http://www.simpleits.co.uk

http://www.tazforum.thetazzone.com

"Google is god...of the internet" - Me

 

[cmmrfrds]

Where are you executing the SQL from? The QBE or other?

 

[MichaelRed]

SELECT * FROM table1 IN 'C:\remote_db.mdb /pwd password'

note the single quotes



MichaelRed