COnnection string to query an access table linked to a SQL DB

[SteveFowkes]

Hi wonder if anyone can help please...........

I need to specify a COnnection string to query an access table linked to a SQL DB(which is on another server)

I have tried something like below, but get an error

ConnectionSQL.Open "ODBC;DRIVER=SQL Server;SERVER=x;WSID=xxxx;DATABASE=xxxxx;Network=x xxx;UID=xxxxx;PWD=xxxxxx"

Any help gratefully received !

[ranman256]

cant you just LINK in the table, instead of a connection string?

[ItsMe]

I use DAO and the QueryDef object. Here is one example.

    Dim db As DAO.Database
    Dim qdf As DAO.QueryDef
     
        Set db = CurrentDb
        Set qdf = db.QueryDefs("TestQueryName")
'        Set qdf = db.CreateQueryDef("TestQueryName")
        
        qdf.Connect = "My Connection String"