Problem with Access 2010 database Runtime error
I do not know if this is the right place to post this.
I am having a problem with my access data base.It was created in access 2003-2007. I am running Windows 7 and Office 2010.
Everthing worked fine two weeks ago and now I am getting a runtime error in my code for updating a user search drop down box.
The error is Runtime 429 Activex component can't create object. Here is part of the code in the after update module.
This was created years ago in Windows XP. I have removed Office 2010 and reinstalled it. No Luck. I have tried regsvr dao360.dll and supposedly the file was restored.
The code is below.
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset THIS IS WHERE I GET THE ERROR.
I hope someone can advise me.
Thanks for your help.
Rick

Problem with Access 2010 database Runtime error
#1
Posted 13 December 2014 - 06:51 PM

#2
Posted 13 December 2014 - 09:52 PM

I just tried to run the database on another computer that has Windows XP and Access 2010 and it worked fine. So it may be a Windows 7 problem on this computer.
How can I resolve this?? Do I need to post in the W 7 forum?
Thanks
Rick
#3
Posted 14 December 2014 - 12:11 AM

I had a problem with the OSK that was resolved by deleting an upgrade. When I deleted the upgrade all went well. Could this be a similar problem?
It happened after several updates from Microsoft.
Please advise
Rick
#4
Posted 14 December 2014 - 03:54 AM

You're trying to load Office 3003 components with Office 2010. Try this
Download and install Office 2003 Add-in: Office Web Components from http://www.microsoft...s.aspx?id=22276
#5
Posted 14 December 2014 - 07:37 AM

Thanks for your reponse Teacher. I will try this. Is there a way to convert the database to Access 2010?
Rick
#6
Posted 14 December 2014 - 07:43 AM

I tired this and it did not work to solve the problem. It appears that this is for viewing on the web. I am running the databae locally.
Any more suggestions would be greatly appreciated.
#7
Posted 15 December 2014 - 11:31 AM

#8
Posted 15 December 2014 - 04:43 PM

I am not sure that this applies. I developed the database one computer. Transferred it to another computer and it works fine. Both computer are running XP. I am try to get the database to run on a new Windows 7 notebook.
I can send more detailed information about the error if that would help.
Thanks for your reply. Please stick with me as this has been frustrating me for days. I tried to ask the questions in the Microsoft Community and so far no reasonable result.
Rick
#9
Posted 16 December 2014 - 03:04 AM

#10
Posted 16 December 2014 - 04:17 PM

I have given up on using ADODB objects. I have begun converting all my code to DAO. So far with a few changes everything is working well.
There have been many suggestions here and on another forum. Thanks to everyone for you inputs.
For future reference I will be happy to share my changes.
This tread may be closed.
Thanks everyone!
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:






