[sabhaVB]

Hello to All,

I am using Crystal Report 8.5 for designing reports.

The problem is when I try to set location of database of the Report from VB it is Crystal Report is giving error : "File Integrity Error".

The database to which I am setting location is in Access 2000 format.

This database was changed from Access 97 to Access 2000.

On some machines program runs without any error and on some machines it is giving error.

If any one knows anything on this problem, please reply.

Any help will be appritiable.

sachin

[Keithuk]

To access a database you normally need references to object libraries. Depending on which database format you are using DAO or Adodc. Check in your references for Microsoft DAO 3.51 will be used for an Access 97 database if its Access 2000 then you need Microsoft DAO 3.6. Or Microsoft ActiveX Data Objects 2.8 Library if you are using Adodc. Usually the highest number you have.

I haven't used Crystal Reports for a long time but check if there are any references in there as well. When you use the old Data control you have to specify the database type in the Connect property.

[sabhaVB]

Hi,

I am using ADO 2.7 as reference in VB project.

I have installed MDAC 2.7 on the client machine. But I am not been able to view report through Crystal Report Viewer

sachin

[Keithuk]

Think about it you have to buy and register Crystal Report 8.5 therefore if you make an app and distribute it the new user will have to register this ActiveX before they can use it.

Who's installation package are you using?