Tools -> References in the VBA editor will show you the current libraries in use (including the ADO version number).

John

For named parameters, put:

cmd.NamedParameters = True

in your VB/VBA code. You need to be using ADO 2.6 or newer for this to work.

To pick up a return result set:

Dim rs As ADODB.RecordSet

Set cmd = New ADODB.Command

With cmd

.ActiveConnection = ActiveProject.Connection 'or your connection object

.CommandText = "dbo.usp_Whatever" 'Proc Name

.CommandType = adCmdStoredProc

.Parameters.Refresh

.Parameters("@BatchNo") = 1

.Parameters("@DateUpdated") =...

Is this an upgrade (on the same server) or are you moving to a different box?

Before even considering upgrading to SQL 2005, I'd upgrade this server to SQL 2000 SP4,...

I'd also learn about running your SQL services under an account that is not a member of the Administrator group on your server.

If you're running SQL 2000 its not easy,...

PSPad (www.pspad.com)

Freeware MDI text editor with colour syntax highlighting for a huge number of formats, including SQL.