DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 11 of 11

Thread: How to compact .mdb and get feedback

  1. #1
    SY Kim Guest

    How to compact .mdb and get feedback


    Do you know how to compact .mdb file and
    get feedbacck on the progress
    while compacting a .mdb file.

    Thank you in advance.

  2. #2
    Michael Cole Guest

    Re: How to compact .mdb and get feedback

    SY Kim <easymanual@dreamwiz.com> wrote in message
    news:3cc4720b$1@10.1.10.29...
    > Do you know how to compact .mdb file and
    > get feedbacck on the progress
    > while compacting a .mdb file.


    Progress status is not provided by the compaction function. You know that
    little progress bar at the bottom of the Access screen that occurs when you
    compact from within Access, its not real. Its only a device to let you know
    the progress is continuing.




  3. #3
    SY Kim Guest

    Re: How to compact .mdb and get feedback


    "Michael Cole" <michael.cole@hansen.com> wrote:
    >SY Kim <easymanual@dreamwiz.com> wrote in message
    >news:3cc4720b$1@10.1.10.29...
    >> Do you know how to compact .mdb file and
    >> get feedbacck on the progress
    >> while compacting a .mdb file.

    >
    >Progress status is not provided by the compaction function. You know that
    >little progress bar at the bottom of the Access screen that occurs when

    you
    >compact from within Access, its not real. Its only a device to let you

    know
    >the progress is continuing.
    >
    >
    >


    Thank you for your reply.
    Would you tell me where you get the information.
    I want to show a progress in my project even if it is not real.


  4. #4
    Bernie Guest

    Re: How to compact .mdb and get feedback


    "SY Kim" <easymanual@dreamwiz.com> wrote:
    >
    >"Michael Cole" <michael.cole@hansen.com> wrote:
    >>SY Kim <easymanual@dreamwiz.com> wrote in message
    >>news:3cc4720b$1@10.1.10.29...
    >>> Do you know how to compact .mdb file and
    >>> get feedbacck on the progress
    >>> while compacting a .mdb file.

    >>
    >>Progress status is not provided by the compaction function. You know that
    >>little progress bar at the bottom of the Access screen that occurs when

    >you
    >>compact from within Access, its not real. Its only a device to let you

    >know
    >>the progress is continuing.
    >>
    >>
    >>

    >
    >Thank you for your reply.
    >Would you tell me where you get the information.
    >I want to show a progress in my project even if it is not real.
    >


    Hi,

    Try to keep track on the temporary DB-file Access is creating during repair/compact.
    Even if you don't know exactly the size it would have upon completion, you
    might estimate it somehow regarding the size of the original file.
    About the progressbar, -It's true it now and then just guess what's happening,
    but when it comes to compacting it recives some info about the true progress.
    Just compare it's behaviour when compacting different db-sizes...

    Bernie

  5. #5
    Paul Clement Guest

    Re: How to compact .mdb and get feedback

    On 22 Apr 2002 23:20:52 -0800, "SY Kim" <easymanual@dreamwiz.com> wrote:


    "Michael Cole" <michael.cole@hansen.com> wrote:
    >SY Kim <easymanual@dreamwiz.com> wrote in message
    >news:3cc4720b$1@10.1.10.29...
    >> Do you know how to compact .mdb file and
    >> get feedbacck on the progress
    >> while compacting a .mdb file.
    >
    >Progress status is not provided by the compaction function. You know that
    >little progress bar at the bottom of the Access screen that occurs when
    you
    >compact from within Access, its not real. Its only a device to let you
    know
    >the progress is continuing.
    >
    >
    >

    Thank you for your reply.
    Would you tell me where you get the information.
    I want to show a progress in my project even if it is not real.

    Unfortunately this isn't really possible (without a major hassle). The call to the function is
    synchronous so your application won't be able to execute any other code to even fake the progress of
    the function.

    You're better off simply displaying a message that compacting is taking place before execution of
    the function, and then displaying a message after the line code that performs the compact has
    completed.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  6. #6
    Ray Mercer Guest

    Re: How to compact .mdb and get feedback


    > Thank you for your reply.
    > Would you tell me where you get the information.
    > I want to show a progress in my project even if it is not real.
    >
    > Unfortunately this isn't really possible (without a major hassle). The call to

    the function is
    > synchronous so your application won't be able to execute any other code to

    even fake the progress of
    > the function.
    >
    > You're better off simply displaying a message that compacting is taking place

    before execution of
    > the function, and then displaying a message after the line code that performs

    the compact has
    > completed.


    Forunately the ANIMATE_CLASS window class was built into Win32 to allow an
    animation control to run in another thread while your synchronous code is
    executing. I believe the VB anim control uses this class internally so you can
    play an AVI file of a progress bar, spinning globe or whatever you want to
    indicate that something is happening. This won't help indicate progress but it
    may be a better choice than a plain message.

    If you want to get fancy, check out using the WinAPI versions at Karl Peterson's
    site http://www.mvps.org/vb/ (AniCtr.zip) and/or check out the Animation Library
    at Randy Birch's site http://www.mvps.org/vbnet/index.html...avi/index.html

    HTH,
    Ray Mercer
    www.shrinkwrapvb.com



  7. #7
    Roger Guest

    Re: How to compact .mdb and get feedback


    The decision whether to provide feedback depends on the size of the database.
    Based on my experience, any database less than 10Megs which is routinely
    compacted will take so little time that it is simply not worth providing
    feedback. I just disable the button the user clicks to start the process
    then re-enable it when it is done.

    Roger

  8. #8
    rick Guest

    Re: How to compact .mdb and get feedback


    Can someone provide the command text for invoking the compact, I assume it
    is a stored procedure call?

    Thank you in advance.


  9. #9
    Menghraj P Guest

    Re: How to compact .mdb and get feedback


    Hey Kim

    i dont know how to show progress bar while compacting is going on but if
    u wanna do compacting from ur VB code then u need to refrence DAO dlls and
    create dbengine object and call compact method of this object
    get back to me in case u have any problem on the above


    regards
    Menghraj P



    "SY Kim" <easymanual@dreamwiz.com> wrote:
    >
    >Do you know how to compact .mdb file and
    >get feedbacck on the progress
    >while compacting a .mdb file.
    >
    >Thank you in advance.



  10. #10
    Michael Cole Guest

    Re: How to compact .mdb and get feedback

    rick <rdmcleod@bigfoot.com> wrote in message
    news:3cc6b25a$1@10.1.10.29...
    > Can someone provide the command text for invoking the compact, I
    > assume it is a stored procedure call?


    This thread is purely for Jet (MS Access .mdb) databases. It is invoked via
    either DAO or ADO.

    For compacting other databases, refer to the specific database help.



  11. #11
    S.Y. Kim Guest

    Re: How to compact .mdb and get feedback


    Thanks for your information.

    I think the suggested method will be an alternative to the progress.


    "Ray Mercer" <raymer@mvps.org> wrote:
    >
    >> ?Thank you for your reply.
    >> ?Would you tell me where you get the information.
    >> ?I want to show a progress in my project even if it is not real.
    >>
    >> Unfortunately this isn't really possible (without a major hassle). The

    call to
    >the function is
    >> synchronous so your application won't be able to execute any other code

    to
    >even fake the progress of
    >> the function.
    >>
    >> You're better off simply displaying a message that compacting is taking

    place
    >before execution of
    >> the function, and then displaying a message after the line code that performs

    >the compact has
    >> completed.

    >
    >Forunately the ANIMATE_CLASS window class was built into Win32 to allow

    an
    >animation control to run in another thread while your synchronous code is
    >executing. I believe the VB anim control uses this class internally so

    you can
    >play an AVI file of a progress bar, spinning globe or whatever you want

    to
    >indicate that something is happening. This won't help indicate progress

    but it
    >may be a better choice than a plain message.
    >
    >If you want to get fancy, check out using the WinAPI versions at Karl Peterson's
    >site http://www.mvps.org/vb/ (AniCtr.zip) and/or check out the Animation

    Library
    >at Randy Birch's site http://www.mvps.org/vbnet/index.html...avi/index.html
    >
    >HTH,
    >Ray Mercer
    >www.shrinkwrapvb.com
    >
    >



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