Run-time error '430': Class does not support Automation or does not support expected

Views: 66

VBA get this message on some computers. "Run-time error '430': Class does not support Automation or does not support expected interface". I use win 7 registered and office 2010 activated.
How to solve this problem.

I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime.

Error 430: Class does not support Automation or does not support expected interface
It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?

If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access.

I have an Access 2007 adp project that loads custom ribbon from SQL server when starting. I actually created an autoexec macro that runs a public function which loads the ribbon. The project adp and ade files run and load the ribbon without problem but when I copy the ade file to user machine running Access Runtime, he gets an error "Error 430: Class does not support automation or does not support expected interface".

Acutally the problem is not with autoexec macro because if I change the macro to open a form, then there is no problem.How can I solve this problem?

I recently purchased a new laptop with the 64bit win 7 OS, I have installed office 2003. my problem is that after working on my database app on the laptop on copying back to my main development machine (xp 32bit office 2003 )I recieve an error when running adodb functions ( Class doesn't support Automation (Error 430))

I am facing the run time error '438': Object doesn't support this property or method. It works fine from last 15 days & at sudden by yesterday,gives me this error in all Treeview/Listview controls of M/S common controls 6.0 (SP2). Can anyone help me in this issue

group
the below error suddenly appeared today.
Been using database for a few years, but lately started going back and forth between access 2007 and the older one.
(getting previous version doesn't help)

"The expression "On Load" you entered as the event property setting produced
the following error: Object or class does not support the set of events.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro

I've got a form where a customer can place an order. now at the bottom i want to put an execute statement which will look at the product ID that has been ordered and make sure that it dont allow that one to be entered again. This is the coding I've got atm to do that:

I'm using data in Access to populate an Excel spread sheet through automation. I open a form in Access (frmdlgDateandSelection_ExportTimeUsedWeekly), fill in the start and a stop date (txtStopDate), and the code populates the spread sheet.
One of the tasks that it does is to insert four dates one week apart in column A.
Sometimes it runs and other times I get this error:

Microsoft Visual Basic
Run-time error '1004':
Method 'Cells' of object '_Global' failed
Accompanied at the bottom by the End, Debug and Help buttons.

An .mde created in Access.03 when run in Office.07 Access gets into a Automation Error. No such error exist when the same .mde runs in WinXp.SP3.

Some questions I hope to get some answers.
1 What is the significance of this error?
2 Is win7 or .64bit causing this error to occur?
3 How this error related to OLE Automation reference that exist in the particular .mde