Trouble with multiple machines reading same data for report

J

Jason

In my setup, I have several W2K computers accessing one .mdf back end file. When a piece of information is looked on any machine an update query is run to add a date when that information is viewed. The problem is that when machine 1 reads the information, it will only show up on a report run from machine 1. When you view the information again on machine 2, it will only show up on a report run from machine 2. ( and has now disappeared? from the report on machine 1, if you run it again ) Both computers are using the same back end file and the information is in the correct field when viewing the back end tables

Any help?!?
 
Top