Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2002

    Unanswered: Mud Bubble Syndrome. The DB expands without control and then explodes and corrupts

    I need some help. I've made an application in VB6 with a DB in Access 2000 and I use ADO. The problem seems to be that The DB expands without measure and then crashes down. If I open the DB I get an error message and I am prompted to "Compact and Repair". After that it runs smoothly For about six or seven hours. Then it starts all over again.
    Why?. This is a multiuser enviroment (five PCs), The DB is located on the server, I use both ADODCs and recordsets opened normally and linked to a connection object.

    Thank you very much for your help.

    PS. The easy way would be compact the DB manually, but I need every user out of the app. And the site is running on a three shifts 24 hour basis.

    Also (as an X file). Often I have to run the "compact & repair" twice, and once, I compacted the DB via Terminal server and I could open and work with it perfectly. The end-users couldn't get the DB running though.
    Last edited by Vetinari; 03-18-02 at 12:33.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts