Improve company productivity with a Business Account.Sign Up

x
?
Solved

ActiveX component can't create object Access 2003

Posted on 2006-07-14
10
Medium Priority
?
1,234 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
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…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

606 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