A good one. Access DB and Project Server

F

fer_diaz

Ok, you have a DB in Access with a bunch of things and a plan in project server. Is it possible to put information into one of them and replicate it to the other application.
Is it possible if I use SQL server in the same server the Project Server is to store the information?

Or is there no way to communicate between these two?

Thanks
 
Z

zack

In the SQL server you can use the linked server under the Security node and add your access DB through there. This way you can write statements in your SQL Server db that use the tables in your access DB.
 
Top