CompactDatabase

Discussion in 'ASP General' started by Christopher Brandsdal, Jul 27, 2003.

  1. 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
     
    Christopher Brandsdal, Jul 27, 2003
    #1
    1. Advertising

  2. Christopher Brandsdal

    Ray at Guest

    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" <> wrote in message
    news:...
    > Anyone know? hmm..
    > /////////////////////////////////
    >
     
    Ray at, Jul 27, 2003
    #2
    1. Advertising

  3. 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:...
    > 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" <> wrote in message
    > news:...
    > > Anyone know? hmm..
    > > /////////////////////////////////
    > >

    >
    >
     
    Christopher Brandsdal, Jul 28, 2003
    #3
  4. Christopher Brandsdal

    Ray at Guest

    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" <> wrote in message
    news:...
    > 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:...
    > > 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" <> wrote in message
    > > news:...
    > > > Anyone know? hmm..
    > > > /////////////////////////////////
    > > >

    > >
    > >

    >
    >
     
    Ray at, Jul 28, 2003
    #4
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Christopher Brandsdal

    CompactDatabase

    Christopher Brandsdal, Jul 25, 2003, in forum: ASP General
    Replies:
    1
    Views:
    100
    Ray at
    Jul 25, 2003
Loading...

Share This Page