Solved

Access 97 and Crystal Reports  4.6 fails when used in a Visual basic 5.0 Service pack 3 application

Posted on 2006-07-07
7
375 Views
Last Modified: 2013-11-25
I have an application written in Visual basic 5.0 service pack 3. This application writes data into an Access 97 database and then invokes a Crystal Report 4.6.1 version (The version that comes with VB5).

The .exe is in a server folder . When you execute the application, from  a PC it runs well . From other PC the report don't show some registers of data, the sums and totals are consistent with the data in the report, but not with the real total that includes those lost registers.

The access 97 database has all the records in the PC that fails to bring the right answer.
If you invoke the Crystal Reports program, open the report and see the preview, it shows all the registers of data as in the Access 97 database, but if you invoke the application, it shows less registers in the same report.

I have run the application setup procedure to install the application in both computers and both have Windows XP Pro.

What can I do to solve this problem?

thanks
0
Comment
Question by:japerez2004
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 17058882
Hi japerez2004,

Check the versions of msjet40.dll on each machine.

Pete
0
 

Author Comment

by:japerez2004
ID: 17073184
I have more information now.

PC #1: The pc where the application runs fine.
PC #2: The pc where the application fails.

The MSJET40.dll is 4.0.8618.0 in pc #2  and 4.0.6218.0 in pc #1.

The VB5 service pack 3 application is using the DAO2535 compatibility layer.
Both pc has DAO3.51 version 3.51.1608.0
The database used is Access 97 in the application
The Crystal Reports version is 4.6.1.122 in both pc
The Crystal Control used by the application is Crystl32.ocx version 8.0.0.4 in both pcs.
Access 2003 in spanish version 11.5614.5606 in pc #2 and Access 2003 in english version 11.5614.5606 in pc #1

I tried to recompile the application in pc #2, but the behavior is the same.
I tried to use MSJET40.dll in pc #2 from pc #1 unregistering the pc #2 version and registering the pc #1 version, but nothing happens again.

Also, I configured Cristal reports to don't use indexes but the problem continues.
The ocx has version 8 due to a product called Seagate Analysis installed in the pc #2. I don't know why pc #1 has it.

help please!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 17104893
japerez2004

peter57r, might be able to provide more information on this...

But here is my theory.

Running, Access 97, VB5.0 and Crystal Reports 4.6.1, on a WinXP machine *might* be the best thing to try.

Win XP was designed to run with Office XP. (Access 97 was 2 versions "Old" at that time.)

Access 97 was around at the time of Win95 and Win9x.

I personally only rely on compatibility going back 2 versions.

Because subsequent versions of Windows include updates to things that have to do with other, newer products. Your combination of products may not be fully supported by the most current version of Windows.

Let's take DAO for instance. In Acc97, it was the default (I believe). In Acc2000, Microsoft wanted people to move to ADO. In Office XP and 2003,ADO is installed by default,  DAO is included for backward compatibility only. I don't even know if Microsoft issues updates for DAO anymore.

Let's also look at Crystal Reports. When V4 was created, Crystal Reports was owned by Seagate. Now it is own by a company called Business Objects. I'm pretty sure C.R. won't "officially" support versions older than 9.0 (Current version is 11)

Finally let's look at VB. Even on my Win 2000 box, I get updates relating to .NET, not VB. On my VB6.0 install disk, I see no file date later than 10/19/1998. and that's for VB6.0! I don't even recall when VB 5 was popular. So that makes VB5 at least 10 years old.

What I am trying to say is that you are slowly "aging out" of support for your older apps.

I would not really try playing any tricks with registering/Unregistering controls, as this may cause problems with you current Apps.

peter57r, to you have anything to Add/Correct/Clarify on this matter?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 77

Expert Comment

by:peter57r
ID: 17106710
I can't add anything useful now.  The poster might be one of a very small population with this config so there is no experience to draw upon and anything one says is just a guess (based on other experience ).
The main thing to check is the list of references - I can't recall the menu structure for VB5 but I guess it was still Tools>References - and for each reference look at the versions on each machine and make sure that the problem machine is brought into line with the OK machine, if necessary.
Unless you have ensured that both machines are running the same software there is no point in looking for other reasons.

Pete
0
 

Author Comment

by:japerez2004
ID: 17112340
I am trying to detect differences in the 2 machines: The one that runs and the one that not. Until now,I didn't find anything.

thanks.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 17461631
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

jjafferr
EE Cleanup Volunteer
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 17489730
PAQ
ee ai construct, community support moderator
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question