Visual Basic/VB, Query Inner join in different database with password

microsoft.public.vb.general.discussion - Microsoft Visual Basic


Visual Basic/VB >> Query Inner join in different database with password

by atjbat » Wed, 12 Apr 2006 20:10:53 GMT

Good morning

Buongiorno
I have a problem in this query with 2 db (access97 + vb6) i have the
second db with password

rsLingua.Open "SELECT A.Id,A.Descrizione" & _
" FROM " & "testi.mdb." & "testi" & " A" & _
" INNER JOIN " & "pluto.mdb" & ".Segnali" & J & " B" & _
" ON A.Id = B.Id " & _
" WHERE B.abilitato=TRUE" & _
" AND B.abilitato=TRUE" & _
" ORDER BY B.Id"

This query it's ok if i don't use password,but in the db :"pluto.mdb"
there is a password and i receive the error
"Password not valid".

How to make to insert the password in the query?

bye


Top

Visual Basic/VB >> Query Inner join in different database with password

by Jeff Johnson [MVP: VB] » Wed, 12 Apr 2006 21:09:11 GMT







First, I recommend asking this in an Access newsgroup, since this really
doesn't have anything to do with VB. Second, Jet SQL supports an IN clause
(not the same as the IN operator) where you specify all sorts of information
about the external database, and password is something you can supply. Check
into it.




Top

Visual Basic/VB >> Query Inner join in different database with password

by atjbat » Thu, 13 Apr 2006 14:41:01 GMT

Excuse me but is the first time that i write/read in the group.I search
the access newsgroup
bye and tankyou


Top
Similar Threads

1. How to retriever info from a SQL Inner Join query with SYSTEM.MANA 

Hi!

I run this query but I'm unable to read the returned objects...

How should I handles objects returned from a SQL Query like...

"SELECT SMS_Program.CommandLine, SMS_Program.Comment, 
SMS_Program.DependentProgram, SMS_Program.WorkingDirectory, 
SMS_PackageStatusDistPointsSummarizer.SourceNALPath FROM SMS_Program INNER 
JOIN SMS_PackageStatusDistPointsSummarizer ON 
SMS_Program.PackageID=SMS_PackageStatusDistPointsSummarizer.PackageID Where 
SMS_Program.ProgramName='SoftWare (Setup 6 of 6)' And 
SMS_Program.PackageID='ABC00123' And 
SMS_PackageStatusDistPointsSummarizer.SiteCode='ABC'"

Thanks!

ShrimpyOne

2. Open a Database by VB Code to join a different workgroup

3. Join tables from different databases? 

Is it possible to join tables from different databases?  If so, what is the 
format of the select statement?  Both databases are on the same server.
TIA,
-- 
Terry

4. join with different database in SQL Server under vb 6

5. Join tables with different database in SQL Server 

Dear all,

Could anyone help me to join table with different database for one recordset 
??
How to build the connection in ADO??

Pls give me the sample code.

Thanks,
Jason.

6. How to Join tables in different database?

7. Inner Join In VBA

8. LIKE % % with inner join - VB.Net