"SOLVED!!" problems once app is installed.. yep! i'm brilliant!

[myrrdan]

Ok, i am having nothing but trouble with this.
Ok, first a lil bit about the program. Its a barcode file generator. Bascially among other options, they click to send a report of a horse. They enter the horse ID number, the program grabs data from a few different tables, inserting it into positions on the form. Then they have the option of creating a barcode file.
This grabs the data, puts it into a csv file, saves the file, then asks if you want it printed.
This is where i always get the problem. It is supposed to open & print a Crystal report file. which is cleared before printing, then the data from a temporary table is inserted. (the temporary table is filled from the form if they say yes they want to print.)
Then once data is inserted, its supposed to wait a few seconds, to make sure its loaded & then send it to the printer. Then close the file.
Then the user can email the csv file if they wish.

Now, on mycomputer, running as code, or as the exe it works fine. But the moment I install it on another computer, it starts acting up. Before it was refusing to close word, fixed that, then it wasn't printing, fixed that (thats why i have the time delay), now it says it can't open the database to insert data into the report.
Which doesnt make sense at all.
The database is the same one that the program uses throughout. So if the rest of the program can find it, why can't the report?
I've installed in Program Files, no change. I installed using the exact same directory structure as the source code is in, and no change either.
I'm at a loss as to why the database & report are screwing up.

I'm using
Access 2003
Win 2000
VB6
Crystal Reports 8

Does anyone have the slightest idea what might, even in the smallest way, be wrong?
I have absolutely no idea how to fix this, and having her run the program onmy computer is out of the question...

AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH

[MartinLiss]

How are you installing? Are you just copying files or did you use the P&D Wizard or Inno, etc.?

[myrrdan]

oops, sorry, i'm using the P&D wizard.

[BrianS]

Same MDAC versions?

The Database on another PC or contained with the code on the installed PC?

[myrrdan]

The database, the access & windows versions are all the same.

All the files necessary are included with the program on its install.

[myrrdan]

OK, i've found something..

When it installs i get this error..


Error registering

c:\winnt\system32\msado21.tlb

[myrrdan]

I"M BRILLIANT!!!

honest, really, i am..

lol

i found the problem..

the rpt generated by Crystal Reports was looking using a hard coded path to the database...
Once i told it to use the form path. it found & opened the database without a problem!

WHOO HOOO!!!

FINALLY ITS ALL DONE!!!!!!!


now i'm gonna run away b4 they decide to add more stuff!!!

lol