Stored procedure/Macro...

[Guest]

I have several databases in my department each with special difffunctions in
the department. Each contains an employee table... My boss does not want the
Employee table to point to one backend... So that means if a new wmployee
comes in today, I will have to update all the databases each at a time.

Bearing this mind is there a way it could be easy to update the several
databases at once using a macro or stored procedure?

 

[Arthur]

Ayon kay JOM:

I have several databases in my department each with special difffunctions in
the department. Each contains an employee table... My boss does not want the
Employee table to point to one backend... So that means if a new wmployee
comes in today, I will have to update all the databases each at a time.

Bearing this mind is there a way it could be easy to update the several
databases at once using a macro or stored procedure?

just a suggestion.

Say you have 3 departments(HR,Admin,Production)
Why not deleting the employee table in HR and in Admin
and link the employee table of Production to HR and Admin.

So will have only 1 employee table and you can update it everywhere
and the update made in 1 department is visible to all departments.