[AccessD] packing a dbf from within Access 97

The other thing you need to cater for BL (and I'm probably teaching my
grandmother to suck eggs, as we say) is that any indexes on the dbf must be
open so they get reindexed.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Boogie Loogie
> Sent: 18 March 2005 22:13
> 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
> 
>