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

Name:  form1.jpg
Views: 360
Size:  24.9 KB

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

Name:  form2.jpg
Views: 357
Size:  26.0 KB

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