none
MDB Files and Access 2013

    Question

  • 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.



    Thanks



    Phil

    Wednesday, May 29, 2013 1:42 PM

Answers

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
    http://www.AccessMVP.com/djsteele (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

    Phil

    Wednesday, May 29, 2013 3:05 PM