Compact - Repair made easy?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing txt files that are 60-70% blank space. I parse them and sort
them into tables to later work with. My issue is that the db gets huge and I
now know that Access doesn't release deleted space until you Compact the
database.


Is there an easy or slick way that users won't notice or see to perform this
function? Could I just add it to the end of my import/parse code?

Thanks again,

-Steve
 
Hi, Steven.
Is there an easy or slick way that users won't notice or see to perform this
function? Could I just add it to the end of my import/parse code?
Click to expand...

Your users will notice, because it takes some amount of time to compact a
large database, but they'll see an hourglass, so they'll know something is
going on. If you have Access 2K or newer, then you can use the code on the
following Web page to compact the current database:

http://www.mvps.org/access/general/gen0041.htm

If you have Access 97 or earlier, then the following Web page has some
excellent alternatives:

http://www.mvps.org/access/general/gen0013.htm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
You may want to create a form that displays an advisory to the users
that there's behind the scenes processing going on. I built a DB several
years ago in which several startup queries had to run. To help with
things, I created just such a form.

David H
 
Back
Top