Results 1 to 3 of 3

Thread: Access Db Compact

  1. Sep 17th, 2002, 05:15 AM #1
    cybercool
    cybercool is offline

    Thread Starter
    Member
    Join Date
    May 2001
    Location
    Rouen
    Posts
    58

    Access Db Compact

    HELLO!

    I would like compact my ACCESS DATABASE with a vb code

    How can i do?

    Thank's

    Cybercool
    Reply With Quote Reply With Quote
  2. Sep 17th, 2002, 05:39 AM #2
    oh1mie
    oh1mie is offline
    Frenzied Member oh1mie's Avatar
    Join Date
    Sep 2001
    Location
    Finland
    Posts
    1,043
    http://www.vbforums.com/showthread.p...hreadid=185571
    oh1mie/Vic

    Reply With Quote Reply With Quote
  3. Sep 17th, 2002, 05:41 AM #3
    CADMANdo
    CADMANdo is offline
    Member
    Join Date
    Aug 2002
    Posts
    33

    Compact Access Db in VB

    Ensure database is closed. This can be checked by looking for a the database name with an extension of LDB. The dbName must include the the path where the database is included

    dbName = App.Path & "\MyDB.mdb"

    DBEngine.CompactDatabase dbName, dbName & "!!!"
    Kill dbName
    Name dbName & "!!!" As dbName
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width