How do I link Access to Project ?

[jfw]

I would like to link Microsoft Access database to Microsoft project

 

[Rod Gill]

Can't be done. You can link a spreadsheet to Project, but I don't recommend
it. Copy/Paste Link uses the old DDE technology and it's too easy to corrupt
either or both of the files at either end of the link.

Project can save its files to an Access database (File, Save as and format
..mpd or .mdb - same result). pjdb.htm is in one of Project's program folders
and has details of what's in all Project tables. With care you can edit
these tables (read the htm file VERY carefully) and the project file will
open with your edits in place.

 

[Laura G-B]

You don't say which way you want to link or what you need to do.
If you want to create reports in Access from a project database then you can
link tables from project into Access. When you do the Link in Access and look
for the database, project databases are not listed, ut if you look for *.mpd
files and find your project database you will get all the tables listed.

As the previous poster said, be very careful editing any data in any of
these tables. Its very easy to break a project, as I've found out.