Ms Access Connection With Crystal Report 10

Hello Friend

I Have A An Application Using Vb.6 And Crystal Report 10 And Ms Access As Database.

And My Problem Is : The Connection From Crystal Report To Ms Database.

I Am Using Odbc To Connect Vb.6 To Msacces Datbase.

When I Distrbute The Application I Install The Application In Three System And I Put The Database In One System Only.

The Problem Here When I Call The Report It Show Me The Data In The Database Which Was Already There At The Time Of Build Up The Crystal Report Connection.
So I Try To Save Some Data To The Database But When I Call The Report It Show Me Only Those Data Which Was There As I Said.

I Use The Odbc But It Show Me The Same Where When I Save Data To Database I Could Not See Those Data In The Report I Can See Only The Data Which Was There At The Time Of Making The Connection

So Please Help What To Do Inorder To Connect The Crystal Report To Ms Access Database . Thanks
[980 byte] By [hussein2000] at [2007-11-20 0:40:35]
# 1 Re: Ms Access Connection With Crystal Report 10
are you just calling report in crystalviewer or u r passing required query from front end.

if u r calling report directly then make sure report is connected to correct access file.
sraheem at 2007-11-9 14:06:27 >
# 2 Re: Ms Access Connection With Crystal Report 10
Hi

Thanks Fro Reply

I Am Using Sql Query
hussein2000 at 2007-11-9 14:07:27 >
# 3 Re: Ms Access Connection With Crystal Report 10
In Crystal Reports
Open your Report

Menu / File / Options / Reporting
Uncheck --> Save Data With Report
Check --> Discard Saved Data on Open

Menu / File / Rport Options / Reporting
Uncheck --> Save Data With Report

Save Your Report
jggtz at 2007-11-9 14:08:25 >