Access + SQL Server 2008

[JamworkS]

Hiya all,

I need to connect to a Microsoft SQL Server Database, and manipulate data in there. I can do it with a normal Pass-through query, but that's no good to me because I need to be able to then treat the data with Access.

I've thought of docmd.runsql but there's no option to tell to connect to a different DB. I've got the connection string, but don't know how to link it with VBA, only with a normal Query.

Any ideas?

Cheers.

 

[Galaxiom]

The easiest way is to link the server tables via ODBC.
Another is to use an ODBC DSNless connection string in the query.
Another is to use an ADODB command.