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

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




More information about the AccessD mailing list