P
Patrick
HI again!!
I want to delete a record from a certain table.
My problem is that this as to be done will 2 users or more
are using the application at the same time.
Example: user1 wants to delete record # 543 and user2 is
working right now on record 540. As soon as user1 deletes
record # 543 I want the table to reflect the changes
automatically to any other user presently working in the
same table, gathering data.
So far my code to delete works and I've inserted
a 'Requery','refresh' and 'Repaint' to try to update the
table minus one record. ITs not working to good. when I
delete(user1) and with user2 goto that record, all the
fields show the Word 'Delete'. Put its still there for
everyone to see..
does anyone know of a way to delete and update the table
while everyone is still working on this same table.
Any help will be very much appreciated.
thanx in advance for any help!
Patrick
I want to delete a record from a certain table.
My problem is that this as to be done will 2 users or more
are using the application at the same time.
Example: user1 wants to delete record # 543 and user2 is
working right now on record 540. As soon as user1 deletes
record # 543 I want the table to reflect the changes
automatically to any other user presently working in the
same table, gathering data.
So far my code to delete works and I've inserted
a 'Requery','refresh' and 'Repaint' to try to update the
table minus one record. ITs not working to good. when I
delete(user1) and with user2 goto that record, all the
fields show the Word 'Delete'. Put its still there for
everyone to see..
does anyone know of a way to delete and update the table
while everyone is still working on this same table.
Any help will be very much appreciated.
thanx in advance for any help!
Patrick