Finding Unmatched (with a twist)

[AJordan]

I've designed a database that three people use. Each person has an identical split database on their PC's. However each person is in a different state. I'm trying to figure out a way in which they can send me a copy of their data table, I append the work they did, and then send them the fully updated table. This way we will be able to link our data on a weekly basis and share information.

- The table was preloaded with a list of students (the same on all three)
- There is a form where we enter data via check boxes from questions such as do you subscribe to magazines, Play video games, attend concerts etc.

I tried to use a find unmatched query, but I received nothing back in the results. For example If John Doe was contacted by another user and selected that he attends concerts, how do I get that information to be updated in my database?

 

[vbaInet]

If this is going to be a regular exercise, look into using Sharepoint Server.

I don't see how a database is split if the users are in different States because you won't be sharing the same LAN.

 

[AJordan]

I split all my databases as it is good practice. I have come up with a solution of using and update query and a linked table (for the other file). Sharepoint Server is completely overkill for this type of work.

 

[vbaInet]

Glad you came up with a solution. I hope that solution works for you