Solved

ActiveX component can't create object Access 2003

Posted on 2006-07-14
10
1,170 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 500 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now