ADODB.Connection not displaying when defining a variable

's Computer Specifications

I am trying to use VBA to connect to SQL Server, I am currently running
Office 2003 when I type in Dim Conn as the list of objects appear, but I do
not see the ADODB with in the list

Any suggestions would be greatly appreciated
Tonis

's Computer Specifications

Have you set a reference to ADO in the VBE ?

Tim

"ToniS" <(E-Mail Removed)> wrote in message
news:C51E0590-534C-4562-826A-(E-Mail Removed)...
>I am trying to use VBA to connect to SQL Server, I am currently running
> Office 2003 when I type in Dim Conn as the list of objects appear, but I
> do
> not see the ADODB with in the list
>
> Any suggestions would be greatly appreciated
> Tonis

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Defining a Variable	=?Utf-8?B?UGhpbCBI?=	Microsoft Excel Programming	3	22nd May 2006 12:04 PM
Defining a variable within a sub...	aking1987	Microsoft Excel Programming	1	11th Nov 2004 12:32 PM
Help with defining variable	Annon	Microsoft Access Form Coding	1	24th Jul 2004 12:00 AM
RE: defining ADODB.xxxxxxxxxx	Francis Hand	Microsoft Access VBA Modules	0	30th Jun 2003 08:22 PM
Re: defining ADODB.xxxxxxxxxx Type	Dirk Goldgar	Microsoft Access VBA Modules	0	30th Jun 2003 03:45 PM