Rebecca, check your data window (Windows/DataSession) to see if you are issuing your commands to the right datasession. If the form closes leaving tables open, VFP goes back to the default datasession. You can close everything there, but there may be a number of other datasessions open.
HTH
Barbara
>I'm trying to close the database file.
>
>
>>Rebecca ,
>>it seems you are mixing the terms database and table
>>database is a collection of tables,views, relations etc.
>>a table in an entity in the databse
>>so what are you trying to close there the table or the database that
>>contains it?
>>
>>Arnon
>>
>>
>>> I'm using a form to browse a database and then a pageframe to display the
>>
>>> record.
>>> When I return to the menu the database file is still open.
>>>
>>> I have tried close databases, close tables, close all to no avail. Even
>>
>>> tried auto close in the
>>> data environment.
>>>
>>> Any thoughts?
>>>
>>> Thanks and have a great day!
>>>