Thanks, that worked great!


>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
>   * compact MDB failed
>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!