Open Connection to remote SQL Server DB from access 2002

[Guest]

Open Connection to remote SQL Server DB from access 2002

How do I open a connection to a remote DB in SQL Server from Access 2002. I
am using the ADODB Connection to do this, but I can’t figure it out… I don’t
think it should be so complicated. (basicaly trying to connect from like
Iraq back to the states).

Basically what I have is an access database that I am trying to use to send
batch updates to an SQL Server DB. The best way that I can think of doing
this is to work with the ADODB.Connection and ADODB.Recordset (s) to work it
out.

Thank you

 

[Sylvain Lafontaine]

If you want some information about the connection strings:

http://www.able-consulting.com/ADO_Conn.htm
http://www.connectionstrings.com/

If you have some problem, I suggest that you ask the DBA responsible for the
remote SQL-Server for the proper connection parameters. You can also create
an empty ADP project (from Access) and use its File --> Connection... -->
Data Link Properties dialog window to make sure that your connection
parameters are valid.

Finally, this newsgroup is about ADP. There are other newsgroups more
appropriate than this one for using ADODB objects from Access.

S. L.

 

[Guest]

Thanks for the help!

Sorry about the wrong newsgroup.