Linking database possibility?

[TigerNoire]

Hi,

My question is kind of vague but here's my situation... I have two databases, one to track payroll and one to track vacation/sick time. Some, but not all, vacation/sick time info comes from the payroll database but is manually entered into the vacation/sick time db. Is it possible to get the two databases to talk to one another and update the information without having to manually enter it? Any help/suggestions are much appreciated!

Val

 

[MikeRBS]

If these are your databases, you could export the tables from one into the other and then run just the one database.

You can alternatively link relevant payroll tables into your sick/vacation db whereupon you can move data between tables or join data from linked and resident tables in the same way as you would do for purely local tables.

Type link in the Help Answer Wizard

 

[willir]

Hmmm. You got my mental juices working on this.

I have a couple of situations similar to this. One is similar -- track sensitive HR info and OT / sick time. On Novell, a user has to have full access to the database to properly access it. Likewise with an NTFS server. So even with variations of security, it is possible for a shift supervisor to access senstive HR and payroll data if they know what they are doing.

My apporach was to split the databases into two. You are ahead of me here. The HR data is one directory that is severely restricted to keep out prying eyes. Many can access the OT and sick time database. Then I add a few forms for the HR so they can access data in both databases. The trick is to use one employee master file, and key all relevant data of the employee ID.

Can you adapt your database to this approach? It should work.

Richard