vb6: package and deployment wizard

[peterdk]

Hi I am trying to compile the program on my laptop for deployment to my desktop computer using package and deployment wizard. I get the error message "unexpected error number 429 has occurred. Active X component can't create object". The program accesses an access '93 database. Any help would be greatly appreciated

[Eduardo-]

It must be a missing reference.

[DataMiser]

A 93 database? There is no db by that name. Are you talking about the old 16 bit version 1.1? Or perhaps you mean 2003?

Never had that error myself, just wondering if you have the package and deployment wizard set to recompile the exe? What OS and are you running it as admin?

[Bobbles]

Quite a few programmers, do not run their program with full compile in the IDE
Whereas I do that all the time.
Whenever I change some code or whatever -
In the IDE
I use the keyboard combination -
Hold down the ALT key and simultaneously press these keys fsrf
That tells the IDE to Save the current File and Run with Full compile

I do that because I used to hate working all week, and then being told there is an error when I try to make the EXE
At my age, I cannot remember what I did in the previous 7 days that may have caused that error.
Never had that problem since.

It is quite possible that this won't solve the problem you are currently having, but what the heck, try it anyway.
And it is a good habit for the future

[Bobbles]

PS If you really would like to resolve this quickly -
Make a copy of your program, and delete all of the sensitive code out of it, or even all of the code.
Include all of the forms that have controls on them.,
Take a copy of your DB, and delete all of the records in it (if you want).
Attach the trimmed project and DB.

[dilettante]

The PDW is failing because it needs something that is missing.

[peterdk]

A 93 database? There is no db by that name. Are you talking about the old 16 bit version 1.1? Or perhaps you mean 2003?

Never had that error myself, just wondering if you have the package and deployment wizard set to recompile the exe? What OS and are you running it as admin?

Hi. Using Access 2003 database. Laptop computer is running Windows 10. Any help would be greatly appreciated

[Phill.W]

I absolutely agree with this.

In over two decades of using VB "Proper", Option Explicit and Start With Full Compile have caught so many potential bugs for me that I wish there was a way of making this the default way of debugging a program!

Mind you, Ctrl-F5 isn't that onerous. ;-)

Regards, Phill W.

[Eduardo-]

Option Explicit and Start With Full Compile, Ctrl-F5

Exactly!

[DataMiser]

I always use option explicit but I do not set the start with full compile. I will from time to time do the full compile in testing but IMO doing it every time is a bit of a waste of time. Of course on modern pcs your typical vb6 project compiles pretty quickly so not a lot of time lost but still on larger projects there is a noticeable difference and when you multiply that by the number of test runs it starts to add up and when it does throw an error you still have to spend the time to locate it and correct it so not really saving anything.

I find that if you make sure to test the new procedures you add then you usually catch any error and rarely get an error later when you do a full compile.