Hi all,



I have to solve the following issue related to different app in different machine as follows:

1. Project apps (access, on client side, only less than 5 user act as admin)
2. Time sheet apps (dot net apps, with access database, on server side, lots of users, mostly are employee)

The scenario is when there is a changing in 1st apps (Project) for example we are deactivate a project then project data in Apps 2 will be updated.
Therefore the users won't be able to choose the IN-ACTIVE project so the input in time sheet will always be accurate. The flow is like the following

Deactivate Project: Apps 1 >> Update project DB >> Update DB Apps 1 >> Connect DB Apps 2 >> Update
Create Project: Apps 1 >> Update project DB >> Update DB Apps 1 >> Connect DB Apps 2 >> Update

AFAIK, if I need to setup DSN to Apps 1 then I have to share the DB Apps 2 in our network. My IT might not agree with this.
Or is there any way around so Apps 1 can update DB Apps 2 without setting DSN?

Appreciate for any feedback for this case

Regards, sea