>Hi David,
>
>Thanks for your help :>
>
>But I was using Visual Foxpro to create that system, is there any way to do it in Visual Foxpro way.
>
>Thanks
>Aston
Check out the compactdatabase method:
oa=create("access.application")
oa.dbengine.compactdatabase("d:\temp\olddb1.mdb","d:\temp\newdb1.mdb")
Access needs to be installed on the client computer for this to work.