CompactDatabase

  • Thread starter Christopher Brandsdal
  • Start date
C

Christopher Brandsdal

Hi!
I found a database tool-script that has a functin for compacting the
database....
What is the point of compacting the database? Is it necessary?
Anyone know the advantages of doing this???


a short copy of the code
////////////////////////////////////////////////////////////////////////////
/
var oJet = Server.CreateObject("JRO.JetEngine");

oJet.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
sDbFName,
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + sTempDbFName);
////////////////////////////////////////////////////////////////////////////
/




Thanks a lot in advance.

best regards Christopher
 
R

Ray at

Frees up junk space from deleted records, reseeds autonumbers, where
applicable. I personally think it's generally a good idea to compact from
time to time.

Ray at work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top