473,322 Members | 1,405 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,322 software developers and data experts.

Run time error 429 Active X Component can't create object

60
I have an Access database (Access 2003). I am running Windows 2000. Until recently I have been able to run VBA code within this database on my machine but lately when I try it I get the Run time error 429 Active X Component can't create object error when the code reaches the following line

Set db = DBEngine(0)(0)

This is part of the code below.

Expand|Select|Wrap|Line Numbers
  1. Dim db As Database
  2. Dim rs As Recordset
  3. Set db = DBEngine(0)(0)
  4. Set rs = db.OpenRecordset("maxtraffic", dbOpenTable)
Can anyone tell me what I need to do to solve this? I can't understand why it used to work and now it doesn't!!!

Thanks
Jan 18 '10 #1
1 6856
nico5038
3,080 Expert 2GB
Checkout http://support.microsoft.com/kb/319844

Nic;o)
Jan 18 '10 #2

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

Similar topics

0
by: Tom Loder | last post by:
Can anybody shed any light on this issue ??? Or even ways of temporaily getting around it ??? FISH is an ASP application which uses a WSC object called "finapps.fishapp" to handle the requests...
6
by: Bill | last post by:
Hi I am having a problem with a com object on WinXP Pro. It is properly registered, but gives me the following error: Server object error 'ASP 0177 : 800401f3' Server.CreateObject Failed...
0
by: Edward Diener | last post by:
In Borland's VCL it was possible to divide a component into design time and run time DLLs. The design time DLL would only be necessary when the programmer was setting a component's properties or...
1
by: John Gabriel | last post by:
I have set up a website and am testing ASPs. I have created a very simple ActiveX component with two interfaces: AboutBox() - displays About details calcpi() - returns 3.14159 Here is my...
2
by: Shihao Png via DotNetMonster.com | last post by:
Well, the problem I'am having now applies to web applications only. Therefore, I believe it has something to do with security settings. Here's the code: ...
1
by: John Gabriel | last post by:
I have set up a website and am testing ASPs. I have created a very simple ActiveX component with two interfaces: AboutBox() - displays About details calcpi() - returns 3.14159 Here is my...
5
by: amitbadgi | last post by:
Hi guys, I am getting the following error in teh insert statement , I am converting this asp application to asp.net, here is teh error, Exception Details:...
0
by: davidcm | last post by:
I inherited a Visual Basic application. I made some changes to it and put the .exe back out on the shared server where it runs. Some users run just fine. But some users are seeing the following...
1
by: rmohanrao | last post by:
Hi All, I have copied a project from production system to my system, to test the project. When I run the project it is giving the error "Run-time error '429': ActiveX component can't create object"....
11
by: xenoix | last post by:
hey there, im reasonably new to C# and im currently writing a backup application which im using as a learning resource. My PC :- Visual Studio 2005 .NET Framework 2 Component Factory Krypton...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.