VBA between MS Project & MS Access

[RockNRoll]

I will be designing a tool soon that will require data to be synchronized
between fields in MS Project to fields in an MS Access database.

Does anybody have any references or code examples that I could use as a
reference?

I am an intermediate coder in Excel and Access VBA.

Thanks,

-Dave

 

[JackD]

read the document called projdb.htm which you can find on the project cd. If
you have the data saved in an access database it is easier to deal with
keeping it syncronized.

-Jack

 

[RockNRoll]

Thanks for the reply. I read the info on Access in the file you referenced
below. How do I get the tables to show up in MS Access? Thanks,

 

[JackD]

From Project:
File menu/
Save as/
choose either project database (mpd) or access database (mdb).
Access can open either one.

-Jack