Hi all
i'm having DBF Tables as my datasource with ADO,
my problem is when i'm deleting the records.... they are not actually deleted but only have marks on the records..
the only way is to PACK the table, but  i don't know, is there anyway to PACK it from ADO?




thanks alot
eshtrim

why dont you convert them to mdb? If  you cant, you would probably need to search for mdb<->dbf convertor, if it exist.

____________________________
If you find the answer helpful, please mark this topic as solved.

hi goran, thx for answering
i already found a way.....
i can pack database from executing command from the connection.execute "PACK x.dbf"
but u must disconnnect the connection first.

with CN
     if .state = adstateopen then .close
     .open
     .execute "PACK x.dbf"
end with

note: i'm connecting my connection with "Provider=VFPOLEDB.1;"

thx