Visual Basic

  • Thread starter Thread starter fc
  • Start date Start date
F

fc

When open an access database in new installation pc, a
warning massage pop up "run time error 430" "Class does
not support automation or does not support expected
interface. When I debug code, it point to the following
line:
Set con = Application.CurrentProject.Connection

It works fine for old machine. Please help!
 
I try that but "object does not support this property or
method" message error pop up.
Click to expand...

There was a rumour that Access 2003 was reversing the ADO-by-default plan
of the last two versions and going back to the original DAO-by-default.
Have you checked to see that there is a valid reference to the ADODB
library in the new PC setup?

HTH

Tim F
 
Hi Tim,

Where could I set up ADODB library
-----Original Message-----


There was a rumour that Access 2003 was reversing the ADO- by-default plan
of the last two versions and going back to the original DAO-by-default.
Have you checked to see that there is a valid reference to the ADODB
library in the new PC setup?

HTH

Tim F

.
Click to expand...
 
Where could I set up ADODB library
Click to expand...

Open the VB Editor, choose Tools | References and see if

Microsoft ActiveX Data Objects

is checked; if not, find it and check it on. If it is already checked then
you have a different problem!

At the same time, if you are not using any DAO code, then UNselect the
following

Microsoft Data Access Objects

Hope that helps


Tim F
 
Back
Top