?
Solved

ActiveX component can't create object Access 2003

Posted on 2006-07-14
10
Medium Priority
?
1,214 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

764 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