Hi,

I have an application that at the begining delete some DBF files that are "connected" to a database (they are not free tables, because i need big field names). So, as i enter at the application i do:

LOCAL i
OPEN DATABASE DBC() EXCLUSIVE
IF ADBOBJECTS(abc, 'TABLE') > 0
WAIT WINDOW "Deleting temporary files..." NOWAIT
FOR i = 1 TO ALEN(abc)
IF USED(abc(i))
USE IN (abc(i))
ENDIF
DROP TABLE (abc(i))
NEXT i
RELEASE abc
ENDIF

But, when we have 60 files this become a nightmare for the user, since it take a lot of time. It there any way to delete these files, in a quicker way? NOTE: i cannot use DELETE FILE, otherwise it will give me errors because the "connection" to the database isn't deleted.

Any idea?


Thanks in advance.