Hi Folks,

I am using ODBC connectivity for VFP Tables with Crystal Report viewer. The Procedure is as follows:

1. I am creating a temporary DBF (12345678.DBF) using SYS(3) for fetching data from multiple tables.
2. At run time I am changing the Data Source and Location for Crystal Report.
3. After viewing the report on screen when I select the different set of data in the same temporary DBF (12345678.dbf), I am getting the error "File access denied".

I think Crystal report viewer is using the data table in Exclusive mode and is not releasing it after report completion.

Please help me in sorting this problem.

Thank you all in advance.

Pramod