crystal report and vb6 naming problem

Question

0.00/5 (No votes)

See more:

please help me.

i have this files
1) Payments.mdb - First Payments, Second Payments, etc....
2) Payments.rpt
3) the vb6 project.

in crystal report, i set the database location to First Payments.

but in vb6 adodc. i received an error like the table or query 'First' is not correctly spelled.

but when i changed the name to FirstPayments (as one whole word) no more error in vb6 but crystal report couldn't open the file. i try to re-locate the database in rpt file but something i noticed is the file name is still First Payments though in mdb i already changed it to FirstPayments.

now in my mdb file are FirstPayments, SecondPayments, etc....

now my problem is in crystal report.
a msgbox says.
File could not be opened: "FirstPayment", at file location "First Payments".

what should i do?????????

Posted 23-Jan-15 22:11pm

JiRoIrO

Add a Solution

2 solutions

Solution 1

I believe that the best advice would be not to use VB6. It has retired long long ago. From Wikipedia:

Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. Extended support ended in March 2008.

Instead you can download the free Express version for Visual Studio from Visual Studio Express[^] and start using Visual Basic .NET (or C# if you like).

What comes to Crystal Reports, you can download it from SAP[^] site.

Posted 23-Jan-15 22:29pm

Wendelius

Updated 23-Jan-15 22:31pm

v2

Comments

JiRoIrO 24-Jan-15 7:17am

thanks for the info. but im hoping that someone could help me with this error. i need to finish this project first before trying another one.

the only question i need answer is how to connect two words name in vb6 if there is a way.
coz it only reads one word file name.

Wendelius 24-Jan-15 10:04am

As pointed out by Chill60 try using brackets around the table name.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2015-01-24T03:06:00

In general it is not a good idea to have spaces in table names (or fields, or databases).

If you are going to stick with the name "FirstPayments" then you need to make sure that you have changed it everywhere - your second error sounds as if you have not updated the RPT file.

The first error you had can be overcome by surrounding the table name with square brackets [] i.e.

[First Payments]