473,386 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Activex component can't create object

489 256MB
I have a friend using Access 2003, I sent him a access database that works just fine on my machine, the first time I ran the program on his machine it worked fine. I didn't make any changes to the program, I closed the program and went back and started it again and this time when I opened the program I get the "Activex component can't create object" I open the program in design mode and check the references, there are no missing references. I've checked each reference to the references on my machine that the program works fine on. Everything is there. I tried doing a trace on the open program but the error comes up before it get to where the trace is to start. I'm starting the trace in many different places just to be sure I check the opening of the program but it still never reaches and of the trace points.
I hope this makes sense to someone and they can point me in the correct direction to getting this fixed.

Thanks in advance for any help.
Dec 12 '13 #1
1 3940
zmbd
5,501 Expert Mod 4TB
Make a backup

For now, if you have any opening code, comment or take it out.

The following is an unsupported feature; thus, I make no guarantees and you use it at your own risk!!!!!!!:
Make a shortcut to Access on the offending machine.
Create a new shortcut to Access and add the decompile switch:
so that for an OFFICE2010 install on a Win7(64b) machine you should have something that looks like this:
Expand|Select|Wrap|Line Numbers
  1. "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" /decompile
NOTE the double quotes... these are actually there! I forget what the path and everything was for ACC2003... but it will be something like the afore when done.

Now drag a copy of the offending file, with all startup code disabled, ontop of this shortcut.

If all goes well the DB will open without error.
Close
Make another backup of this new decomplied file
Open the decompiled file using the normal method on the offending PC
VBA - Compile
Database tools compact and repair
close
reopen
re-enable your normal opening vba

See what happens. If this continues then there is an issue with the local PC... and it's simply not possible to go thru everything... either the Office install is bad or something in the OS... could be something in the ActiveX component you're using. If you developed the applicaition in ACC2007/2010/2013 even though you may have saved it as a ACC2003 file, there are some strange things that happen with these files and that could be the unknown issue.

BOL.
-z
Dec 12 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: sonu | last post by:
I am tring to create activexobject like var Fo =new ActiveXObject("Scripting.FileSystemObject"); but i am finding error that automation server cant create object any help
1
by: Alex Shirley | last post by:
Hi We have various machines with Windows 2000 Pro and Windows XP Pro. Note all machines have Office XP Pro installed + Outlook 2003 We have a Microsoft Access 2002 database that sends out...
7
by: Munsifali Rashid | last post by:
Hi, I've built a webservice in C# that can add public folders to Exchange. There's also a component built in VB6 which references the Outlook 10 (XP) DLL, so I can change the default form being...
3
by: Steve Richter | last post by:
running a simple vbscript in an .htm page that starts excel and loads the spreadsheet with the contents of a <table> ... </table> getting an "Error: ActiveX component cant create object....
1
by: erotikaboi | last post by:
Guys, Firstly let me say I am a photographer so if you can offer me a solution I will really appreciate it in simple english not techiespeak as I wont understand it. Thanks. Ok, I am using Access...
2
by: sysadmin | last post by:
Hi Iam trying to install MRP 9000 on windows xp professional.I get an error that activex component cannot create object-error in error routine. Can you help me in fixing it? thanks
1
by: vanessak | last post by:
Hi , I have been trying to use wizards in Access to create new tables and quieries etc but everytime I try, this message pops up. I have tried removing and reinstalling the program but nothing seems...
1
by: mahesh123 | last post by:
Hi Folks, I am getting an Error "Activex Component Cannot Create Object" While I am exporting the Data from the MSFlexgrid to the MS Excel. Here In my Client System MSOffice is not Installed....
2
by: premMS143 | last post by:
Hi, I've created a small VB application which uses VISDATA as a backend. Here I used SQL statements for all Queries. This works well in WIndows XP. But when I try to install it in UBUNTU.,its...
1
by: jdub33 | last post by:
I have a web project that used a vb6 class library. The asp page would call a createobject() to access the class library. I recently updated the vb6 class library to .net2005. I unregistered the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.