Access DB update problem, how can i wait for database to have written the data
Posted on 2004-03-30
I currently have a Booking program, a server, and a CashRegister. These are three different Visual Basic program, both the CashRegister and the Booking program interacts with each through the server.
Now thats actually working fine my problem even though is this
I am using a Access Database as database for the program, each program opens a connection to the database and gets all kind off information this way, now the problem is at some point my Booking program updates some information in the database
dim rs as adodb.recordset
set rs = new adodb.recordset
rs.open "Select * from regning_vare",frmfront.cnxn,adOpenDynamic,adLockOptimistic
!vare = "Ol"
After this the Booking program tells the Server that it has done an update in the database which the other clients should be aware of, the server tells the clients to update their information, the problem here is that the information has not yet been updated in the database, which at some point gives errors or at least wrong information.
My question, how do i make my booking program wait to tell the server that it has done an update until it has actually been written to the database ?