MDB Files and Access 2013


  • Hi all

    I have taken delivery of the first PCs with Office 2013 and am trying to
    iron out the Access wrinkles.

    We use an Access database split into front and back ends.

    With previous versions of Access, it has been possible to simply create
    a shortcut to the front end file to launch the app.

    If I browse to the front end file in Windows Explorer, it is clear that
    Access is not associated with the mdb file.  However, if I launch Access
    and navigate to the front end, the Access icon is shown agains the file
    and it launches OK.

    Having Googled, there was some info about pre-2000 databases (and this
    may have been originally created in Access 97). So I did a SaveAs to
    create another front end file specifically in Access 2000 format.
    Windows/Access still do not appear to associate this mdb with Access, as
    the icon is still blank sheet.

    Can anyone suggest a solution please, such that the front end can be run
    from a short-cut and launch Access?

    The back-end was created around the same time, so there may be other
    issues which haven't yet surfaced.  Any advice on this would be
    appreciated also.

    Notes: Front end on Dell Optiplex 7010 desktop with Windows 7 and MS Office 2013 - both up-to-date I believe.  Backend on Windows Server 2008 R2 Standard.



    Wednesday, May 29, 2013 1:42 PM


All replies

  • >>Can anyone suggest a solution please, such that the front end can be run from a short-cut and launch Access?<<

    Have you try :

    "Fullpath To Your MSAccess.exe" "Fullpath To Your MDB file"

    as the command-line for your shortcut icon?

    Van Dinh

    Wednesday, May 29, 2013 1:51 PM
  • That's odd: when I checked the machine that's only had Office 2013 installed, .mdb files are associated with Access.

    When you select the .mdb file in Windows Explorer, there should be an Open option under the address bar. If you click on that, you'll get a chance to associate the file extension with a program.

    Doug Steele, Microsoft Access MVP (no e-mails, please!)
    Co-author Access Solutions — Tips, Tricks, and Secrets from Microsoft Access MVPs (ISBN 978-0-470-59168-0)

    • Marked as answer by X-Phil Wednesday, May 29, 2013 3:05 PM
    Wednesday, May 29, 2013 2:02 PM
  • Thanks Doug

    I was looking for something more exciting than just a loss of file association.

    No idea why the association should be there from within Acccess but not when outside of it IYSWIM.

    The association seems to have resolved the shortcut launch and the addition of the /runtime switch option also seems OK (I notice that others have had problems with this).

    Many thanks


    Wednesday, May 29, 2013 3:05 PM