Results 1 to 12 of 12
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to .mpd tables (2000)

    Does anyone know how to link to tables in a .mpd format database? This is a Microsoft Project database. The .mpd file will open in Access but I can't seem to link to my .mdb database.

    The .mpd format isn't available from the list of file types listed when linking tables, therefore the .mpd file is not a visible option and can't be selected.

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

    Re: Linking to .mpd tables (2000)

    An .mpd database is a regular Access database, only the extension is different. If you change the extension to .mdb, you can link tables from it in another Access database.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to .mpd tables (2000)

    That works - thanks..... One minor niggle

    The new mdb file now wants to open in Access and not Project. I know I can right click the file and choose open with...

    But is there a way to open this specific file to open with Project by default (without setting Project as the default for ALL mdb files)?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Linking to .mpd tables (2000)

    No, but you can create a shortcut to the file that includes the path to the project executable as well as the name of the database. Double clicking on that should open project and the database.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to .mpd tables (2000)

    Charlotte

    I am doing something wrong...just can't work out what.

    I have put the following in the Start In box :
    "C:Program FilesMicrosoft OfficeOFFICE11WINPROJ.EXE" but I get an error message informing me that the shortcut to the folder is invalid. If i remove the WINPROJ.EXE part the file opens but in Access.

    I am confused

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

    Re: Linking to .mpd tables (2000)

    The subject of your post mentions 2000 as version. Office11 is the install folder for Office 2003. The default path for Project 2000 is "C:Program FilesMicrosoft OfficeOFFICEWINPROJ.EXE".

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to .mpd tables (2000)

    The 2000 refers to Access - The version of Project I have is 2003 standard

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

    Re: Linking to .mpd tables (2000)

    Have you checked that WinProj.exe has actually been installed in C:Program FilesMicrosoft OfficeOFFICE11?

  9. #9
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to .mpd tables (2000)

    Yes - I have checked and it is there.

    The shortcut file is on a network file server and not on my local machine - does that make a difference?

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

    Re: Linking to .mpd tables (2000)

    I'm sorry, I wasn't paying attention (haven't had enough coffee yet). The Start In box is not important. The Target of the shortcut should look like this:

    "C:Program FilesMicrosoft OfficeOffice11WINPROJ.EXE" "F:MyProjectsProject1.mdb"

    or

    "C:Program FilesMicrosoft OfficeOffice11WINPROJ.EXE" "ServerShareMyProjectsProject1.mdb"

    with the appropriate path/file name for the project database substituted.

  11. #11
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to .mpd tables (2000)

    Hurrah - That worked

    Thank you

    So what does the 'Start In' box do?

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

    Re: Linking to .mpd tables (2000)

    The 'Start In' box is meant for shortcuts to an application, not for shortcuts to a file, but it has lost much of its usefulness. Many applications nowadays have a default folder for opening and saving files that can be set from within the application. All Office applications use a default folder.
    But there are applications that don't have a default folder, such as notepad. For those, you can specify a folder in the Start In box of the shortcut. For example, you could have two shortcuts to Notepad on your desktop, one starting in My Documents, and the other in a network folder.

Posting Permissions

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