Connecting to SQL server using VBA

J

Jerry

Hi

I'm using Word 2007. Trying to make a connection to SQL server, but i get an
error i just can't seem to solve.
It won't pass the first piece of code:

Dim cnDataBase As Connection
Dim rsDingetje As Recordset
Dim SQLStatement As String
Set cnDataBase = New Connection

When it comes to the part "Set cnDatabase = New Connection" then it gives an
error:
Compile error; Invalid use of key-word New.
Tryed different things like
Set cnDatabase = New connection1. Also activated the plugins for DAO.

Thanks in advance,
Jerry

--
 
Top