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

How would I code this so lets say I started off with tblStuff and replaced 
it with tblStuff where tblStuff is a linked dbf table not a native Access 
table?

I have no idea how to do that.

Thanks

Paul

>From: "Arthur Fuller" <artful at rogers.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 11:16:18 -0500
>
>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
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus