updating info in separate tables in separate databases

  • Thread starter Thread starter timglass via AccessMonster.com
  • Start date Start date
T

timglass via AccessMonster.com

I am not sure if this is the correct area but here goes. I have created 2
databases for tracking temps. One is for our Supervisors and the other is
for HR. The HR side has info that the Supervisor are not allowed to access.
The Supervisor version will be on a network drive that is accessible to them
and their Manager. The HR version will be on a network drive that is only
accessible by HR members The problem that I am facing is how do get updated
info from the HR version to the Supervisor version? An example would be when
a temp is relaesed then they would move from current to terminated list. I
would need the Supervisor version to also remove that temp from their current
temp lisr. Since both versions have a table for current temps what I need is
for every time that HR updates their side those changes are reflected in the
Supervisor version.
 
I could not be sure by reading your post whether HR has any access rights to
the Supervisor folder. If they do, then it should not be a problem. I would
suggest you link to the table that needs the updates in the supervisor
version from the HR version, then do your updates.
 
Back
Top