[Resolved] Join SQL and Access table in VB query.

[Skeeve]

Hello all!

This should be simple but I can’t figure it out...

I have a table in SQL and a table in Access that I am trying to join. I have not found any way to do this so I creating two recordsets and manually searching through the records for a match and then created a 3rd record set with the appropriate records. This method does work, however it is VERY slow.

Does anyone know how to join an Access and an SQL table?

An alternative would be to link the SQL table in Access but the SQL table uses SQL authentication and therefore requires me to pass the login name and password. I would also rather not have to create an ODBC connection on every PC i install my software on. Thanks!