Visual Basic

[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!

 

[Alex Dybenko]

try
Set con = Application.CurrentProject.activeConnection

 

[Guest]

I try that but "object does not support this property or
method" message error pop up.

 

[Tim Ferguson]

I try that but "object does not support this property or
method" message error pop up.

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

 

[Guest]

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

.

 

[Tim Ferguson]

Where could I set up ADODB library

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