[AccessD] Can I pack / compact dbf files with Access 97?

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




More information about the AccessD mailing list