William,

I had the same problem reporting against tables and then trying to open the table exclusively in another VFP form. This was remedied with the following code.

IF TYPE('ThisForm.oleCrViewer') = O
ThisForm.RemoveObject('oleCrviewer') && crystal report viewer
ENDIF
IF TYPE('oCrReport') = O
RELEASE oCrReport && report object
ENDIF
IF TYPE('oCrApplication') = O
RELEASE oCrApplication && application object
ENDIF

I am running VFP7 with CR9 and never have a problem with CR keeping the table(s) open.

Jeff