Ricardo,

Don't put your temporary tables into your main DBC. Create them as a free tables or if you need them to be in a DBC create a separate DBC for a temporary tables only.

>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.