Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: file in use
Thread ID: 78998 Message ID: 79052 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, October 12, 2005 2:26:24 PM         
   


> Or more precisely, CLOSE TABLES ALL (Clear all will clear a lot of things that you may not want cleared.)

That will work providing that there is not some other object, or datasession, involved. If the problem is because of some code, or object, hanging on to a reference, or a rogue datasession, then it will not work - which is why I suggested a CLEAR ALL instead.

As I said, we really need to see the code here because there are so many possibilities. But you are correct, perhaps a CLOSE TABLES ALL would be a better (or at least, less drastic) first thing to try.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

ENTIRE THREAD

file in use Posted by MENDEL TOLIBAS @ 10/12/2005 3:37:42 AM
RE: file in use Posted by Andy Kramek @ 10/12/2005 12:21:19 PM
RE: file in use Posted by Ken Murphy @ 10/12/2005 1:44:44 PM
RE: file in use Posted by Andy Kramek @ 10/12/2005 2:26:24 PM
RE: file in use Posted by Ken Murphy @ 10/12/2005 2:30:37 PM
RE: file in use Posted by Andy Kramek @ 10/12/2005 4:59:54 PM
RE: file in use Posted by MENDEL TOLIBAS @ 11/12/2005 2:30:19 AM