Linking to Microsoft Project

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thanks!

Mary Chipman said:
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
Click to expand...
 
Back
Top