Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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
Medium Priority
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?

Question by:japerez2004
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
LVL 77

Expert Comment

ID: 17058882
Hi japerez2004,

Check the versions of msjet40.dll on each machine.


Author Comment

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 in both pc
The Crystal Control used by the application is Crystl32.ocx version 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!
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 17104893

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?
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

LVL 77

Expert Comment

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.


Author Comment

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.

LVL 27

Expert Comment

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.

EE Cleanup Volunteer

Accepted Solution

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

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.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

722 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