[AccessD] packing a dbf from within Access 97

Ah, it's been so long since I had to deal with a true dbf file, that I
forget there really are such things.  I'm sorry to say that I think
that's your only real alternative.  

Charlotte Foust


-----Original Message-----
From: Boogie Loogie [mailto:boogieloogie at gmail.com] 
Sent: Friday, March 18, 2005 2:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com