Database Run-time Error

I'm running an application that uses Crystal Reports.  When I try to open the report from my Visual Basic application I get a run-time error 20534, database dll.  What or how can I fix this?
stepheng051097Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kobe_LenjouCommented:
start with looking up the error code in your manual/help file.
0
stepheng051097Author Commented:
I already tried, that error code was not in the help file.
0
Dr. Kamal MehdiCommented:
What VB version do you use?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dr. Kamal MehdiCommented:
Also, are you running your VB application on your machine, or are you running your compiled EXE on another machine?
0
stepheng051097Author Commented:
Version 4.0 of VB and yes, I am running the exe on a machine that does not have VB installed.
0
Dr. Kamal MehdiCommented:
Well stepheng, let's start step by step:
Did you make a setup diskette using the VB4 setup wizard and installed your application on the users machine, or you just copied the EXE file, the database, and the report to that machine?

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dr. Kamal MehdiCommented:
Also, are you using DAO objects or the VB's Data control and bound controls in your application?
0
stepheng051097Author Commented:
I'm using both DAO objects and vb data controls.  I used Wise installation software to install the application (which inculdes more than the exe, database, and report files) on the machine that has the problem.  Since I've posted the question, I tried installing the application on another machine and don't get the run-time error.  My guess is that something is corrupt on the machine that brings up the error  but I have no idea what.  Any suggestions?
0
Dr. Kamal MehdiCommented:
Well...
It seems that there is something missing on your first machine and is not included on your setup diskettes.
Does the new machine where your application runs has any of the following installed:
- DAO objects
- Crystal reports
- VB
- The Microsoft Jet Database Engine (or Microsoft Access)

Also, I would strongly suggest that you use the VB's setup wizard and you should manually add all dependency files required by the crystal report control (these files are listed in the crystal reports help).
You must also check in the tools - references whether the DAO library is checked (selected).
Regards
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.