Integrating MS Project and MS Access (1 Viewer)

[santhosh23]

Hi

I have designed a database in access which I am using for assigning work to my shopfloor employees . I have designed a card with barcode for them to check their dailywork. I also have a MS Project to make schedule for all the projects in shopfloor . Everytime when I assign work using access database I need to update the project schedule first and then fill the same information in Access database. I really dont want to do this same work 2 times (Updating MS Project and MS Access ) , it actually takes more time . My question is there a way to intergrate MS Project and MS Access database , have anyone tried that scenario?? Thanks in advance

 

[pbaldy]

I haven't done it, but a quick search turned this up:

https://support.microsoft.com/en-us/kb/210014

 

[santhosh23]

@pbaldy

Thanks for the swift reply . I will try to implement it and hope it works. thanks once again.

 

[pbaldy]

No problem. I've used automation on Excel a lot, but I've never used Project. Good luck.