Compacting a DB


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Compacting a DB

  1. #1
    Cat Guest

    Compacting a DB


    I know I'm missing something very, very simple. I can't seem to figure out
    how to run an event that will compact another DB, keep the same name and
    locale. Can anyone help? Thanks.

    cat

  2. #2
    Lt. IJ Guest

    Re: Compacting a DB


    i got the same scenario recently.
    what i did was the folowing:

    -if database is currently used, close it (must open it exclusively).
    -compacting a database produces another file e.g. cpdb.mdb (like a mirror)
    but compacted.
    -get that filename or path of that cpdb.mdb
    -delete or backup the original database
    -rename cpdb.mdb to the name of original database

    this works for me, nevertheless

    "Cat" <cat1173@hotmail.com> wrote:
    >
    >I know I'm missing something very, very simple. I can't seem to figure

    out
    >how to run an event that will compact another DB, keep the same name and
    >locale. Can anyone help? Thanks.
    >
    >cat



  3. #3
    Cat Guest

    Re: Compacting a DB


    Hey. Thanks for the info Jerry! I'll work with it and see what happens.
    Or I can just get the user to go in and compact couple times a week! hehe
    Thanks again!

    cat


    "Lt. IJ" <jerryrflores@yahoo.com> wrote:
    >
    >i got the same scenario recently.
    >what i did was the folowing:
    >
    > -if database is currently used, close it (must open it exclusively).
    > -compacting a database produces another file e.g. cpdb.mdb (like a mirror)
    >but compacted.
    > -get that filename or path of that cpdb.mdb
    > -delete or backup the original database
    > -rename cpdb.mdb to the name of original database
    >
    >this works for me, nevertheless
    >
    >"Cat" <cat1173@hotmail.com> wrote:
    >>
    >>I know I'm missing something very, very simple. I can't seem to figure

    >out
    >>how to run an event that will compact another DB, keep the same name and
    >>locale. Can anyone help? Thanks.
    >>
    >>cat

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center