Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: msaccess.exe /repair in Access2

    I am using Access2 and I can NOT update it to a newer version.


    I am trying to set up InstallMaster to copy database Ti40.mdb to C:\, repair and compact it using the following Access command:

    msaccess.exe c:\Ti40Net\Ti40.mdb / repair /compact

    When it finishes repairing, Access waits for me to click OK !

    I need to bypass this confirmation\acknowledgment step.

    Can someone PLEASE tell me how to accomplish this using maybe a /option or /autorepair or ....

    Any comment will be helpful and appreciated.

    Phantom Tech
    Last edited by Phantom Tech; 04-06-04 at 08:07.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Don't know if this will work in Access2 (to bad you can't upgrade)

    DoCmd.SetWarnings False
    .
    .
    msaccess.exe c:\Ti40Net\Ti40.mdb / repair /compact
    .
    .
    DoCmd.SetWarnings True

    No clue if this will work.

    S-

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    Thanks very much SBAXTER for the info.

    I am self taught (without a book) in Access2 for about a year.

    The company we got TrackIt database from is using Access2 to keep from dealing with all the bells and whistles in the newer versions. I wish they would upgrade to 2000, but until then,

    I am not inside the access database when I execute the " msaccess,exe Ti40.mdb /repair /compact " command.

    If I were in the database, I could REM out the message in the code.

    I do not know how to use the DoCmd.SetWarnings outside the database.

    If there is a way, please help an old man keep his job, he he.

    PT

  4. #4
    Join Date
    Nov 2003
    Posts
    267
    Sorry, I just don't know

    The closest I founs to any information of the subject is

    Microsoft Knowledge Base Article - 209207

    S-

  5. #5
    Join Date
    Apr 2004
    Posts
    3
    Thanks for sharing your time and taking time to research it.

    If I ever figure it out I will let the Forum and/or you know.

    PT

Posting Permissions

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