Arthur Fuller
artful at rogers.com
Tue Feb 11 10:17:00 CST 2003
The simplest way to pack a dbf is to copy it to a new name. Only the undeleted records are copied. Then delete the original, then rename the copy. Hth, Arthur -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: February 11, 2003 10:47 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Can I pack / compact dbf files with Access 97? oooohhhhh. Never mind. 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 Neal Kling Sent: Tuesday, February 11, 2003 10:37 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Can I pack / compact dbf files with Access 97? John, ArcView uses dBase dbf files, not mdbs. Paul needs a way to pack a dBase file from vba. Neal Kling -----Original Message----- From: John W. Colby [mailto:jcolby at colbyconsulting.com] Sent: Tuesday, February 11, 2003 9:56 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Can I pack / compact dbf files with Access 97? 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 _______________________________________________ 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