Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003

    Unanswered: problem compacting .mdb when a connection is open ( .ldb )

    Well , i got an .mdb where is store data about some printers.
    i connect to it thx a dsn and it runs 24h/24.

    i already found a program to schedule few delete sql querry but as it is .mdb it still need to be compacted.

    So i found a .vbs script to compact it but it dont want to run when it is already open in exclusive mode by admin.

    i wonder if some1 can help me with that. i plan to run the programs or script everyday to clean the old data and compact the db.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    not clear to me if you are admin or not.

    if someone else is admin and has opened exclusive, you can't compact - in fact you can't do anything.

    if you are admin/exclusive - you should be able to compact. if this is your case, please add some details.


  3. #3
    Join Date
    Apr 2003
    well in fact, i got installed a server application who collect data and fil an .mdb database , the server software connect to the db via a dsn.

    the connection is in use all the time , so i need to clean & compact sometimes. when i try to compact using a simple vbs script , it says that it is already open with admin right & exclusive.

    the server application got admin right on it.

    so i think i should find a way program or script to close connection & compact.

Posting Permissions

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