[AccessD] vba sql connection question

Just use ADO to read table or view with a connection string that looks 
like this

oConn.Open "Provider=sqloledb;" & _
           "Network Library=DBMSSOCN;" & _
           "Data Source=xxx.xxx.xxx.xxx,1433;" & _
           "Initial Catalog=myDatabaseName;" & _
           "User ID=myUsername;" & _
           "Password=myPassword"

For further info look here through links
To connect to SQL Server running on a remote computer (via an IP address)
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer


George Papp wrote:

>Hello list,
>
>I need to write some VBA code that establishes sql table connections
>on the fly when the mdb is connected and then assigns the new table to
>a from so the user can interact with it. The connection can not use
>dsn and it is to a remote server on the web.
>
>Thank you very much for all your help.
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada