-
Implementation of DSN
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules