I am trying to update a MS Access table based on a table in a MS SQL Server:
Example: Persons 01 to 10 and Rooms A to J
The Table on the server gets updated periodically and I want my Access table to reflect that.
Example: I have an Access table with Rooms A-J in a column, when Person 05 moves from Room A to Room E; I want my table to reflect that.
Is this possible? If so, what is the easiest way? Thanks.