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

    Question Unanswered: Comppress and Repair of Access DB using VB code

    Hello !!!

    A very annoying question I'm writing a small application using VB and ODBC conection to Assess Database (ADO) . Ineed some way for the aplication to preform Compress & Repair of my database.

    Thank You!!

    Sem

  2. #2
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251

    Re: Comppress and Repair of Access DB using VB code

    You can use old DAO.... use RepairDatabase or CompactDatabase methods


    or you can use ADO's brother JRO....

    Dim JRO As JRO.JetEngine
    Set JRO = New JRO.JetEngine

    JRO.CompactDatabase _
    "Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source=C:\md1.mdb", _
    "Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source=C:\md1_new.mdb"_
    & ";Jet OLEDB:Engine Type=4"


    http://support.microsoft.com/default...230501&GSSNB=1



    jiri




    Originally posted by SemSh
    Hello !!!

    A very annoying question I'm writing a small application using VB and ODBC conection to Assess Database (ADO) . Ineed some way for the aplication to preform Compress & Repair of my database.

    Thank You!!

    Sem

  3. #3
    Join Date
    Apr 2003
    Posts
    2

    Talking 10X

    Thank You very much!!!

Posting Permissions

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