Twin Database Issues

[smbarney]

Here is my problem: I have two databases. The first one, call it "A", is accessed by a small group of people and houses personnel information that is updated hourly. The problem is I need to grant access to some of the information to a host of different people...too many to make using the user security a good choice. To solve this problem, I created a second database, call it "B", that only contains a read only form and table and permits people to view the information. This works great. However, my problem is keeping the information between the two databases current, meaning if changes are made in db A those changes have to be reflected in db B. I tried linking the table in B to a table in A but it cause a bunch of errors and prevented the users from accessing the information in db B. Any thoughts on this one? Thanks.