i am trying to use odbccp32.dll in vfp8 to compact an access database using the following code but i don't get an option to pack as it returns a 0 all the time. any ideas much appreciated.

DECLARE short packingaccess in odbccp32.dll Integer, Integer, String, String
lcFile = "D:\company\userdb.mdb"

IF packingaccess(0,1,"Microsoft Access Driver (*.mdb)","COMPACT_DB= " + lcFile)=0
messagebox(fail)
else
messagebox(success)
Endif

Slán
~M