Linking MSProject with MSAccess

[zip]

I am currently developing a project file which schedules different events,
and an access database which contains project stakeholders. It is my
intention to be able to link an event in project to an attendee report in
access, and have both of these applications working over a network.

I have attempted to achieve this linkage through the use of macros shortcuts
and toolbar buttons (hyperlink to the DB and then specify a Report
subaddress). Neither of which seem to work. I am wondering if you know of
another way to do this?

Thanks!

 

[Rod Gill]

Hi,

You can't copy and paste link from Project to Access or vice versa. Instead
you need to write VBA code to update Project from Access or Project VBA code
to read/write data from Access.

If you let us know exactly what you need to do we can give you a head start,
otherwise examples of reading and writing from and to Access are part of my
VBA book. You can also search msdn.microsoft.com for Office Automation and
VBA for some sample code.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[zip]

Hi Rod, thanks very much for you advice. All I want to do is somehow
associate an Project task with a report in Access. I do not wish to import or
read data in, I just need a way to automatically link the two and have it
work over a network.

My last resort is to list the file adress of the database in the task line!

cheers

 

[Rod Gill]

You can certainly create a hyperlink for every Task pointing to an Access
database. Alternatively a little VBA code can start the database and display
the required report.

To create a Hyperlink, select the Task then press Ctrl+K (Insert,
Hyperlink).

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Rod Gill]

In the Insert Hyperlink Dialog, at the end of the file path add #Report My
report name

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com