Hi Charles,
In addition to closing table you have to close database. E.g.:
set database to dbcName
close database
>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?
If it's not broken, fix it until it is.
My Blog