Access Query Recordet conversion to an Array
"TK" wrote ...
I conclude from your post: the ws data only has to be entered in a way
that you can create a search condition
This approach isn't restricted to Jet data sources; odbc sources may
be used. This example uses any Jet connection (e.g. to a non-existent
workbook) to join northwind (Jet) and pubs (SQL Server) tables:
SELECT
MSJet.ProductName, MSSQL.job_desc
FROM
[Database=C:\Program Files\Microsoft Visual
Studio\VB98\NWIND.mdb;].Products
AS MSJet
INNER JOIN
[ODBC;Driver={SQL Server};SERVER=MYSERVER;DATABASE=pubs;UID=***;Pwd= ***;].jobs
AS MSSQL
ON MSJet.ProductID = MSSQL.job_id
;
Jamie.
--
|