Solved

Reduce a DBF File Size

Posted on 2001-06-27
4
1,501 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

839 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