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
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