I have an Excel workbook that connects to an Access
database on the same machine. The workbook has ADO code to
connect to the database. It has worked for years. Recently
I had to move all of this stuff over to another machine. I
copied everything over without any changes EXCEPT:

- The original machine used Windows XP as the OS. The new
machine is Windows 2000 Professional.

- On the original machine I was running Office XP. The new
machine is using Office 2000. I had to convert the
database to Access 2000, but made no other changes.

Now when I run the code in the workbook it gets to this
line:

'Dim cn as New ADODB.Connection
cn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=C:\MyPath\MyDatabase.mdb;"

The error is:

Method 'Open' of object '_Connection' failed

I can open the database manually and run queries with no
problems.

Could someone recommend possible solutions?

tod

Tod,
Have you checked the references of the workbook on the
2000 machine? Could it be that the Data Objects library on
the XP machine is later than the one available on the 2000
machine? For example you may have been using version 2.7
on the XP machine and only have 2.5 on the 2000 machine.
Worth a look anyway.
>-----Original Message-----
>I have an Excel workbook that connects to an Access
>database on the same machine. The workbook has ADO code
to
>connect to the database. It has worked for years.
Recently
>I had to move all of this stuff over to another machine.
I
>copied everything over without any changes EXCEPT:
>
>- The original machine used Windows XP as the OS. The new
>machine is Windows 2000 Professional.
>
>- On the original machine I was running Office XP. The
new
>machine is using Office 2000. I had to convert the
>database to Access 2000, but made no other changes.
>
>Now when I run the code in the workbook it gets to this
>line:
>
>'Dim cn as New ADODB.Connection
>cn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> "Dbq=C:\MyPath\MyDatabase.mdb;"
>
>The error is:
>
>Method 'Open' of object '_Connection' failed
>
>I can open the database manually and run queries with no
>problems.
>
>Could someone recommend possible solutions?
>
>tod
>
>
>.
>

That's what it was. I downloaded MDAC 2.8 and solved the
problem.

thanx,
tod
>-----Original Message-----
>Tod,
>Have you checked the references of the workbook on the
>2000 machine? Could it be that the Data Objects library
on
>the XP machine is later than the one available on the
2000
>machine? For example you may have been using version 2.7
>on the XP machine and only have 2.5 on the 2000 machine.
>Worth a look anyway.
>>-----Original Message-----
>>I have an Excel workbook that connects to an Access
>>database on the same machine. The workbook has ADO code
>to
>>connect to the database. It has worked for years.
>Recently
>>I had to move all of this stuff over to another
machine.
>I
>>copied everything over without any changes EXCEPT:
>>
>>- The original machine used Windows XP as the OS. The
new
>>machine is Windows 2000 Professional.
>>
>>- On the original machine I was running Office XP. The
>new
>>machine is using Office 2000. I had to convert the
>>database to Access 2000, but made no other changes.
>>
>>Now when I run the code in the workbook it gets to this
>>line:
>>
>>'Dim cn as New ADODB.Connection
>>cn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
>> "Dbq=C:\MyPath\MyDatabase.mdb;"
>>
>>The error is:
>>
>>Method 'Open' of object '_Connection' failed
>>
>>I can open the database manually and run queries with
no
>>problems.
>>
>>Could someone recommend possible solutions?
>>
>>tod
>>
>>
>>.
>>
>.
>