Results 1 to 3 of 3

Thread: Compacting...

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Location
    Palermo, Italy
    Posts
    325

    Compacting...

    Anyone knows how to compact a MSAccess database through code??

    Thx.
    Xmas
    Learn, this is the Keyword...

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    I don't know if you still need this or not but I believe if you open the database as an object (referencing the access activex component) then you can compact it from the database object itself.

  3. #3
    Addicted Member
    Join Date
    May 2002
    Posts
    142

    Here is the Answer...

    http://support.microsoft.com/default...b;en-us;306287

    It uses the JRO...


    Be Careful to change the example so that the destination file is different from the orginal file (Compact from, Comact to)

    Good Luck
    Last edited by bebandit; May 11th, 2004 at 09:04 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width