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
329 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
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now