Hi All!
I have this routine in my app in its load event that checks to see if a database table is open or not by this command:

Use dbcName!dbfTable In 0 Alias dbfTable

If opening this database table returns successfully, then loading continues, if not, a message box appears saying that another app is using this particular table. And then immediately following the command earlier is this command:

Use In dbfTable

Now my problem is that if no error occurs (meaning my app is the only app that can use the database tables since i can use dbfTable exclusively) and I try to copy the database file to another directory, an error occurs which reads "File is in use". How come? Didn't I already close the said table by issuing a "Use In" command? What could be a "better" way to close a specific table?