-
August 6th, 2017, 08:21 AM
#1
Help with VB6 refreshing ADODC problem
I have 2 program, very simple VB6 program to add data into ms-access(.mdb) and the other program is just viewing the data.
Program A run on PC-1 and Program B run on PC-2
1. Program A
Private Sub Command1_Click()
Adodc1.Recordset.Addnew
Adodc1.Recordset.Field(0) = Text1.Text
Adodc1.Recordset.Field(1) = Text2.Text
Adodc1.Recordset.Update
End SUb
(Program A is working OK, it just use to insert data into .mdb)
2. Program B
It just datagrid to view data from ms-access. The data was input using Program A on PC-1.
(Program B is working properly to display data, but when I add data from Program A the data was not display last record that I've added)
My problem is when i add the data from Program1, Program2 is not display the data that I have just enter it. These 2 program are running together on each computer.
The datagrid can view my last data only if i close Program B and open it again. If i add command button on Program B to refresh adodc then the data is displayed.
But I need the adodc to automatically refresh when there is data change.
Help me pls
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|