[AccessD] packing a dbf from within Access 97

Actually when using access to delete records from a dbf file they are
infact not deleted. They are only marked for delete. Access recognizes
that files that are marked as deleted, flagged if you will, should not
appear. Other programs need the dbf packed, thus a true delete, or
else the records will display. Not really the fault of either
software...just the way the manufacturers handled the situation when
developing.

Oh well I will try and write my own utility to see what I can come up with.

Thanks anyway.

BL


On Fri, 18 Mar 2005 13:17:22 -0800, Charlotte Foust
<cfoust at infostatsystems.com> wrote:
> There is no "pack" command for an Access database, which is what I
> assume the "dbf" file in question to be.  When you delete records, they
> are gone immediately.  If the records are still appearing in your ArcGIS
> application, then it doesn't sound like the fault is with Access, but
> with refreshing the links the ArcGIS software is holding.
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: Boogie Loogie [mailto:boogieloogie at gmail.com]
> Sent: Friday, March 18, 2005 11:52 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] packing a dbf from within Access 97
> 
> Hello
> 
> Is there anyway to pack a linked dbf file programatically within Access
> 97? When I delete records in a dbf table using my .mdb app the records
> are still appearing in my ArcGIS software but not from the mdb app.
> 
> A packing solution is needed. I hope it is available.
> 
> Thanks
> 
> BL
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>