[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!

[RobDog888]

You save the ODBC password in Access by checking the
checkbox "Save Password" when you create the linked tables.
Then create a File DSN and save it to the network you wont have
to set it up an ODBC on every computer.

[kleinma]

in the access database, link the sql server table (under file menu)

it will look just like an access table except it will have a little globe icon next to it (so that u know its linked) and you cant edit the structure of the table (you would need to do this in SQL Server itself)

now you can do your query off the access database and use both tables as if they are part of the same database...

there is no other way to do this.. (in ADO.NET you can however, connect to 2 different datasources in SQL statements.. pretty cool)

[Skeeve]

Robodog,
Your suggestion worked perfectly! Thank you!

[RobDog888]

Your welcome. Glad to hear you got it solved.

HTH.