MartyConnelly
martyconnelly at shaw.ca
Fri Mar 18 17:22:54 CST 2005
Well you could pack dbf files from VBA if you have a copy of DBASE something like Shell (dbase mypack.prg" where prg file has pack and table name options. or The solutions below here is to export the table to new dbf and break the link then rename dbf file either in code or after exiting access Test this on copies.. DoCmd.TransferDatabase acExport, "dBase 5.0", "C:\mydir\",,"TableName", "mynewfile.dbf" The deleted records should then be removed. There are caveats with shape dbf files http://support.esri.com/index.cfm?fa=listserve.messageShow&m=13020 Boogie Loogie wrote: >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 >> >> >> -- Marty Connelly Victoria, B.C. Canada