Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In Clause connecting to password protected Database. HELP

Status
Not open for further replies.

chris3366

Technical User
Mar 15, 2002
23
US
I am building an query which refers to a table in another database using the IN clause, however the database is password protected.. do you know what would be the syntax in the IN clause to pass the password?


SELECT * FROM tblName IN 'Address /pwd pssword'

I get this a an error message. "Address is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

The path is correct because it is a copy and paste from the address bar. Tried both single and double quotes.


Any help would be appreciated.
 
How are ya chris3366 . . .

Try this:
Code:
[blue]SELECT * FROM TableName IN  '' [MS Access;PWD=password;DATABASE=Path/FileName][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top