Very Computer

1. Cannot add record to Visual Foxpro table after deleting all records in table

After:
1. opening adodb connection with
vfpoledb.dll and datasource=path$ &
foxprofile.dbc successfully
2. deleting all records from table1 in
foxprofile.dbc successfully with
connection.execute("delete from table1") (I
can see the records being marked as deleted
in the VFP IDE) ,

I cannot add any record to table1 that has a
primary key like one of the deleted records.
So I execute connection.execute("pack
table1") and get "ADO error: File is in use".
(but my foxpro IDE is closed and only my VB6
program has the *.dbc open).

How can I delete (and pack if necessary) all
the records so they are gone for good from
the table?

Please!
Thank you.

2. DBPATH problem

3. Cannot connect after delete a .DBF file

4. On error goto not being called when getting an error

5. link an access table to an external dbf file

6. SQL statement problem

7. DELETE records in a DBF file from DTS package

8. delete records in dbf files...

9. purging deleted records from .dbf files

10. Deleted records when text file is linked as table (#deleted)

11. Deleted records in dbf tables

12. Delete the records permanently in .DBF table