Re: Close Crystal reports and free the foxpro table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Do you have exclusive checked in your ODBC?

"Amar" <Amar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02D0A9BF-2270-4FB4-87BC-C3812A32C6EC@xxxxxxxxxxxxxxxx
>I use the following softwares:
> VB.NET (Visual studio .NET 2003)
> Crystal Reports V 8.5
> Visual Foxpro V 8.0
>
> I have a VB.NET application. When i click a button on the application i
> display a windows form with a crystalreportviewer component on it. This
> uses
> a crystal report to display some data. The crystal report pulls this data
> from a foxpro table abc.dbf. Everything works fine till here.
> Now i close the crystal report window and return to my main application.
> Now
> i click the button to display the same report once more. But, this time
> the
> application gives a foxpro error saying that the table abc.dbf is already
> in
> use and cannot access it. So, i close my entire application. Again restart
> my
> application. Now the report runs fine again only once, and give the same
> table access error if i try to run it twice. So i believe that the foxpro
> table gets locked by the crystal report.
> I have added this abc.dbf table as a DSN database. Is there some way that
> on
> closing the crystal report everytime, i should be able to free up this DSN
> database, which will in effect free up the foxpro table abc.dbf???
> Thanks in Advance,
> Amar
> (PS: Cindy, please see if you can solve this)


.

Quantcast