Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Opening the Wrong .MDB (2000/sp3 or sp4)

    Using a shortcut to open a database using the associated workgroup file is there any way to wind up opening a different database than the one specified in the shortcut?
    "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "S:AppPathNorthwind.mdb" /wrkgrp "S:AppPathNorthwind.mdw"
    Where Northwind was secured using a workgroup file placed on the same path and called Northwind.mdw?
    Yes, "S:" is a network drive, but if there was a problem resolving or accessing the mapped drive shouldn't there be an error and not just grab some default database for the particular user?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Opening the Wrong .MDB (2000/sp3 or sp4)

    When this happens to me i get an error saying that it couldn't find the file.

    I have never had Access just open another db instead.
    Regards
    John



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

    Re: Opening the Wrong .MDB (2000/sp3 or sp4)

    My experience is the same as John's: I have never seen a shortcut open another database if the target database was not available.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening the Wrong .MDB (2000/sp3 or sp4)

    Agree with John and Hans.

    Having an MDB file and a MDW file with the same name in the same folder is not a good idea. AFAIK, they will both attempt to create an LDB file, with unknown results. I suggest that you change the name of the MDW file.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Opening the Wrong .MDB (2000/sp3 or sp4)

    Thanks.
    That was my experience also.
    The user can't reproduce the behavior. Am assuming this is a UFO.

  6. #6
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Opening the Wrong .MDB (2000/sp3 or sp4)

    Thanks.
    That was my experience also.
    The user can't reproduce the behavior. Am assuming this is a UFO.
    Also a good point about the possible problem with Lock files. Our standard is to require them in separate directories.

Posting Permissions

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