Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Activex component can't create object

Posted on 2005-02-24
9
Medium Priority
?
253 Views
Last Modified: 2012-05-05
Hello,

When I am in access I cant use any of the wizards because I get the error message:

Activex component can't create object

I have tried going through all the five steps microsoft suggest but this does not fix the problem!

Think it must be a windows problem because I uninstalled Office Xp and tried installing Office 2000 ending up with same error,

Any ideas, ideally I would like to download an .exe file to sort this out for me,

Cheers
0
Comment
Question by:GarethWham
  • 5
  • 4
9 Comments
 

Author Comment

by:GarethWham
ID: 13401481
Hello,

Cheers for the post but it doesn't help
0
 
LVL 54

Expert Comment

by:nico5038
ID: 13401766
Are you sure that the ActiveX component has been registered an is present on the computer ?
Also check the references:
Open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.

As access doesn't cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"

Nic;o)
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:GarethWham
ID: 13402167
There aren't any entries starting with missing,

there are a number of references present but there are only four selected:

Visual Basic for applications
MS Access 10.0 Object Library
MS ActiveX Data Object 2.1 Library
OLE Automation

0
 
LVL 54

Expert Comment

by:nico5038
ID: 13402707
Some thoughts:
1) What happens when you drop the last two libraries and run a Debug/Compile all ?
2) Is there an ActiveX object used in your .mdb ?
3) Did you try a re-install of Office after removing Office first ?

Nic;o)
0
 

Author Comment

by:GarethWham
ID: 13403046
1) nothing
2) no this is before I even start to create a database - try to use form/table wizards
3) Yes completely removed it then tried two different office versions

Cheers
0
 
LVL 54

Expert Comment

by:nico5038
ID: 13403078
OK, then let's assume we have to do with a corrupted .mdb.
Try these MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 

check also: http://www.granite.ab.ca/access/corruptmdbs.htm


Nic;o)
0
 

Author Comment

by:GarethWham
ID: 13404007
Thanks for all your comments,

However surely there should be a simple solution.

It is not a specific database where the prooblem lies. If i just create a blank database go to table wizard it displays this message.

Computer is up to date with SP2 and windows update, how has this happened? Effectively I dont have full use of a product that I have paid for,

Cheers
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 2000 total points
ID: 13404077
Hmm, I'm afraid the source will be somewhere in the windows/access combination.
The real last option I can propose is to re-install both windows and Office.
On the otherhand, when you have system not too old restore points, it might solve the problem to return to a date that Access was working...

Nic;o)
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 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