RT error 430 class doesn't support automation - windows incompatibility [SOLVED]

[smittal]

Hi,


can anyone help me to update msado15.dll in active x control.


I had coded VBA program through which we can extract MS-Access table and displays it on Excel.previously this program works very fine, but after getting system formatting it sows the error (Run time Error - 430 Class does not support automation)..


i think there is a active x control issue.. please suggest..


Help will be highly appreciated.

 

[smittal]

https://www.dropbox.com/s/xllvw16vrgi3uzq/Project%20KRAs.xlsm


Link attached, Error occurring area:-


con.ConnectionString = scon

con.Open

rs.Open xselect, con

 

[NARAYANK991]

Hi Mittal ,


Do you mean to say that your PC does not have the file msado15.dll ?


Can you check the following two links to see whether they help ?


1. http://stackoverflow.com/questions/7690608/adodb-connection-from-vba-stopped-working


2. http://www.forumtopics.com/busobj/viewtopic.php?p=637888


Narayan

 

[SirJB7]

Hi, smittal!

Adding my two cents to what NARAYANK991 told you, I don't know exactly if that dynamic link library is installed by default with the standard Office or Excel installation, but you could check fully update your actual version installing all the available features and then checking if your workbook works fine or it's still reluctant.

To do so go to the Control Panel, Programs, Uninstall. Then select Microsoft Office or Excel, Change, Add or Remove Functions, Next, and click on the proper arrow drop down menu and select "Run all from my PC", Next, and so on.

Regards!

 

[smittal]

thanks to both of you...


error resolved...... in window 7 - SP1 pack was missing...


Thanks