How to show the changes Updated by other user on network
-
I am usin microsoft access as backend database and using dataenvironment in my vb application to connect the database. The problem I am facing with dataenvironment is when I open any recordset from the dataenvironment it get all the records and hold it in the recordset and if I make changes in any field of the record it does not appear to the other users of the network. What technique should I use to solve this problem? THanks in advance.
-
I am usin microsoft access as backend database and using dataenvironment in my vb application to connect the database. The problem I am facing with dataenvironment is when I open any recordset from the dataenvironment it get all the records and hold it in the recordset and if I make changes in any field of the record it does not appear to the other users of the network. What technique should I use to solve this problem? THanks in advance.
ejaz_pk wrote:
What technique should I use to solve this problem?
Diplomacy :) The problem is that Access was meant as a desktop-database, not as a grand-central that can update multiple clients with live data. There are multiple ways of telling the other clients that data hath been altered and that they should fetch the fresh ones. A recordset is a snaphot of data. Once the data changes, you'd either need a new recordset or update the one that you got. Rereading the dataset (with something like a refresh-button) might be the best option. Alternatively, you could create a new table, that lists the tables in Access together with their last-modification date. If you want data from a table, just look into the new table and see if it has been changed. If it has, again, reread the entire recordset. Hope this helps :)
I are troll :)