Linking to Microsoft Project

[Guest]

Can Access data be linked to Microsoft Project? I'd like to be able to
modify data in a MS Project file that will automatically update an Access
database. Can this be done?

 

[Mary Chipman [MSFT]]

You could create a linked server in SQLS to the Jet database, but you
can't link directly. I'd recommend using a linked table front-end to
both Jet and SQLS as this will create less overhead and likely perform
better than an ADP-linked server solution, depending on how you create
your front-end, of course. Heterogeneous queries running in Access/Jet
are never going to be fast if your SQLS tables are large.

--Mary

 

[Guest]

Thanks!

You could create a linked server in SQLS to the Jet database, but you
can't link directly. I'd recommend using a linked table front-end to
both Jet and SQLS as this will create less overhead and likely perform
better than an ADP-linked server solution, depending on how you create
your front-end, of course. Heterogeneous queries running in Access/Jet
are never going to be fast if your SQLS tables are large.

--Mary