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

John W. Colby jcolby at colbyconsulting.com
Tue Feb 11 09:16:18 CST 2003


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






More information about the AccessD mailing list