CompactDatabase
 

Anyone know? hmm..
/////////////////////////////////

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

Re: CompactDatabase
 

I replied nine minutes after your original post. You may have to download
more than the default 300 messages if you're using OE to go back that far.

Ray at home

--
Will trade ASP help for SQL Server help


"Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> Anyone know? hmm..
> /////////////////////////////////
>

Re: CompactDatabase
 

hmm.. strange.
I have chosen to download all massages.. aprox. 19000...
But I can't find the massage..
When you posted the massage nine minutes after me, I got you're massage, but
could not read it.. It was marked with an X... And than it was gone.... can
you copy the text you wrote and paste in a new post?

thanks for helping me Ray! :)

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> skrev i melding
news:OEBJmJIVDHA.2096@TK2MSFTNGP11.phx.gbl...
> I replied nine minutes after your original post. You may have to download
> more than the default 300 messages if you're using OE to go back that far.
>
> Ray at home
>
> --
> Will trade ASP help for SQL Server help
>
>
> "Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
> news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> > Anyone know? hmm..
> > /////////////////////////////////
> >
>
>

Re: CompactDatabase
 

That's odd. Here's the other post:

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 home

--
Will trade ASP help for SQL Server help


"Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
news:urXEBcOVDHA.2032@TK2MSFTNGP11.phx.gbl...
> hmm.. strange.
> I have chosen to download all massages.. aprox. 19000...
> But I can't find the massage..
> When you posted the massage nine minutes after me, I got you're massage,
but
> could not read it.. It was marked with an X... And than it was gone....
can
> you copy the text you wrote and paste in a new post?
>
> thanks for helping me Ray! :)
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> skrev i melding
> news:OEBJmJIVDHA.2096@TK2MSFTNGP11.phx.gbl...
> > I replied nine minutes after your original post. You may have to
download
> > more than the default 300 messages if you're using OE to go back that
far.
> >
> > Ray at home
> >
> > --
> > Will trade ASP help for SQL Server help
> >
> >
> > "Christopher Brandsdal" <christopherwb@c2i.net> wrote in message
> > news:ujLD0iHVDHA.1052@TK2MSFTNGP09.phx.gbl...
> > > Anyone know? hmm..
> > > /////////////////////////////////
> > >
> >
> >
>
>