Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    /compact has now discernible effect (xpPro sp2)

    Whilst trying to use the /compact switch to auto compact a database (access 97 sr2), there appears to be no effect whatsoever and the database merely opens up.

    Any suggestions?

    TIA
    Alan
    Cheshire

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: /compact has now discernible effect (xpPro sp2)

    The command line should look like this:

    "C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" "CatabasesMyDatabase.mdb" /compact

    where CatabasesMyDatabase.mdb is the complete path+filename of the database you want to compact. Does your command line look like that?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: /compact has now discernible effect (xpPro sp2)

    Many thanks Hans.
    I was not including the initial msaccess.exe
    All works fine now.

    Cheers
    Alan

Posting Permissions

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