Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Connection stopped working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Connection stopped working
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Connection stopped working
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel stopped working | Excel Discussion (Misc queries) | |||
Formula stopped working | New Users to Excel | |||
SumByColor Stopped Working | Excel Worksheet Functions | |||
VB Stopped Working | Excel Worksheet Functions | |||
Tab stopped working | Excel Programming |