Solved

Reduce a DBF File Size

Posted on 2001-06-27
4
1,518 Views
Last Modified: 2006-11-17
I have attached dbf files in an access application. The contents of the dbf files are deleted daily and reloaded with fresh data.

The size of these files continues to grow. How can I reduce the size by compact ? or cleaning ? in vba code

Thanks

0
Comment
Question by:pnjones
  • 2
4 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 6233186
I would check the dbase application for an "external" compress. Thus you can issue a SHELL command from VBA to execute the compact.
Another option is to delete the file and to create a new copy and relink.

Nic;o)
0
 
LVL 6

Accepted Solution

by:
PsychoDazey earned 300 total points
ID: 6233457
I am not sure I understand your question, but I will take a stab at it.  Does running the compact method help when you have your database open?  If so, you can set up a db that will run the repair and compact procedures on any number of databases you specify, if you are interested, I can pass that info along to you.
If you are trying to compact another DB (Foxpro maybe?) I agree with Nico, except I would use the ShellEX function.  I also have the code for that.
I have an application that creates a new directory, based upon a variable, copies a file to it and kills the old file.
Please give me more info and I will be happy to assist with any of the methods I specified above.
0
 
LVL 1

Author Comment

by:pnjones
ID: 6234212
nico5038,

The dbf file was created in satellite forms and I cannot find a method to compress the file. Do you know of any generic compress, compact routines for dbf files ?

Thanks
0
 
LVL 1

Author Comment

by:pnjones
ID: 6269819
I used a derivative of your suggestion , I load empty files into a sub folder and copy them across before loading the data

Regards

PAt

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question