For me this is a complex sql string

[jslmvl]

Hi,

In VB6+Access, I got error by the sql string:

sql = "Select * From Table1 Where [User] In (Select Table1.[User] From Table1 " & _
"Left Join (Select Table2.[User] From IN '' [MS Access;PWD=123456;DATABASE=" & aFileName & "] " & _
"Group By Table2.[User]) As t On Table1.[User]=t.[User]) "

Can you correct for me?
I will be very appreciated if you explain how to do such complex sql string.

 

[PHV]

I got error
Which error ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jslmvl]

Sorry, I should have made my question clearer, the error was

Run-time error '-2147467259(80004005)':
Syntax error in FROM clause.

 

[PHV]

I'd use linked table instead of the IN clause.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jslmvl]

I don't know "linded table", can you show me an example?

 

[kjv1611]

I don't know "linded table", can you show me an example?

Try the MS Access Help file for linked table. It's a linked table as apposed to imported table.

PHV is telling you it'd be best to first link in the external table, and THEN refer to that linked table in your SQL code, thus removing the difficult SQL part altogether.

--

"If to err is human, then I must be some kind of human!" -Me

 

[NXMold]

I was thinking of doing something similar, and found the following link explaining that you CANNOT link to another access back end using a password.

http://stackoverflow.com/questions/...connection-string-to-another-jet-mdb-possible