?
Solved

ActiveX component can't create object Access 2003

Posted on 2006-07-14
10
Medium Priority
?
1,230 Views
Last Modified: 2008-04-09
hi there,
I'm trying to run the upsizing wizard in access 2003 but when i click on it i got this error:
"ActiveX component can't create object"
I'm trying to solve by doing what microsoft suggets here: http://support.microsoft.com/kb/q296205/ but it does not work any suggestion?
0
Comment
Question by:jsctechy
  • 5
  • 5
10 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 17110841
What other ActiveX controls have u got?

what steps from MS did u do

0
 
LVL 1

Author Comment

by:jsctechy
ID: 17110868
the 1st one:

1. On the computer that hosts Microsoft Windows Terminal Server or the computer on which Microsoft Access is installed, click Start, and then click Run.
2. Type regsvr32 followed by the path to your DAO file. Enclose this path in quotation marks. For example, to register the DAO 3.5 library, use the following command: regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL"  

>> What other ActiveX controls have u got?
that was the only one so far
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17110970
and when u registered, it registered fine?
sometimes its worth unregistering then re-registering

after u registered, did u check the referenceS? go to vba window/select tools/references
ensue u have latest version checked

to unregister

regsvr32 /u
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 1

Author Comment

by:jsctechy
ID: 17110993
can you be a bit more expecific how do it registerin and unregidtering?
0
 
LVL 1

Author Comment

by:jsctechy
ID: 17111007
this is what i got on that message after i run what i was asked to run:

RegSvr32
dllRegisterServer in C:\program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL succeeded.
0
 
LVL 1

Author Comment

by:jsctechy
ID: 17111057
when i try to open the preferences i got this error:
your microsoft office access database or project contains a missing or broken reference to the file 'DAO350.DLL' version 5.0.
i think is related to the error i have before
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17111280
no probs
u have registered it, right?

Now scroll thru and u may find its shown as MISSING

Uncheck it (Microsoft DAO Object Library is the name)

click ok,

Now go back into References and check it (the latest version 3.6 I believe)
then click ok
0
 
LVL 1

Author Comment

by:jsctechy
ID: 17111287
i was in there but none of them have MISSING
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 1000 total points
ID: 17111300
to unregister,
its

regsvr32 /u "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL"  

this removes the registration

now u register it again

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL"  



Now typing this in, I realised its DAO350.DLL. This is the old version

so this is what I suggest u do, try the later version

'get rid of old
regsvr32 /u "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL"  

'add in new
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"  

0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17111914
Did u get any success registering DAO360
then add that as a reference
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question