Data consistancy Problem in Reports

Dear All,

I m using VB6 and Crystal reports 8 and Access 2000.different drivers for data access for my vb6 applicatiopn i m using Micosoft jet oledb 4.0 and for my reports i m using ODBC.The prob is when i update record in vb6 application and run the report the report shows me old data plz, help me how to overcome this prob.

I can not use ODBC driver with my application the reason being it does not support transaction thats y i m using oledb provider.


and also i m using parameter query in access database when i convert the driver of crystal report it does not show me parametr queries. only odbc driver shows me parameter queries as stroed procedures.

Thanx in Advance