Hi Steve,
Uses API function SQLConfigDataSource from ODBC:
DECLARE Integer SQLConfigDataSource in odbccp32.dll Integer, Integer,String, String
LOCAL lcNew,lcFile
lcNew="c:\temp\compact.mdb"
lcFile="c:\temp\Data.mdb"
IF SQLConfigDataSource(0,1,"Microsoft Access Driver (*.mdb)","COMPACT_DB= "+lcNew+" "+lcFile)=0
ELSE
ENDIF
MartinJ
>I am sending/receiving information with an Access table via ODBC, but the file appears to be growing even though I mark the records as deleted when I've finished importing. I noticed on the graphical version of the driver that I can compact the file.
>
>Is there a way to do this from within VFP 7?
>
>Thanks!