Paul Black
pblack at hotmail.com
Tue Feb 11 10:14:30 CST 2003
Hi I tried this but it did not work. Got an "unrecognized database format" message. I need something that allows access to recognize the internal delete byte of a dbf format table. Paull >From: "John W. Colby" <jcolby at colbyconsulting.com> >Reply-To: accessd at databaseadvisors.com >To: <accessd at databaseadvisors.com> >Subject: RE: [AccessD] Can I pack / compact dbf files with Access 97? >Date: Tue, 11 Feb 2003 09:56:21 -0500 > >You can do that from a command line switch. Something like: > >\my Office Path\Office\Access.exe /compact "myMDBFileName" > >Essentially you are running Access, telling it to compact a database. If >you get it running (in a dos box) then turn it into a batch file it will >run >and close when finished. Note that all users have to be out of the >database >to compact a database. > >John W. Colby >Colby Consulting >www.ColbyConsulting.com > >-----Original Message----- >From: accessd-admin at databaseadvisors.com >[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Paul Black >Sent: Tuesday, February 11, 2003 9:21 AM >To: accessd at databaseadvisors.com >Subject: [AccessD] Can I pack / compact dbf files with Access 97? > > >Hello > >Is there an add-on, code, whatever that will allow me to pack / compact dbf >files with Access 97? > >I have a GIS (geographic information system)called ArcView 3.2 that does >not >recognise the delete flag within a dbf file. So when deletes occur to a >linked dbf from within Access they still appear within the GIS. > >I do not want to have to purchase a dbf program just to pack so was hoping >someone out there had the same experience and found a solution. > >Regards > >Paul > >_________________________________________________________________ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > >_______________________________________________ >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 _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail