Hi, gaubun.
Do you want to work with both as a single one or do you want work with each?
If you are mentioning the first, then I would like to stay that it is generally a bad practice.
Hi Fish,
Thanx for your concern.
"Do you want to work with both as a single one or do you want work with each?
If you are mentioning the first, then I would like to stay that it is generally a bad practice."
Actually I am merging some village databases to its upper level i.e Subcenters or SCs database and then will use latter to generate reports. I am not going to manipulate ANY OF THE VILLAGE DATABASES. SC database is a temporary one...used only for report generations.
Suppose if I have two village databases (A and B) and one EMPTY DATABASE WITH SAME STRUCTURE (i.e C)
Now what I want is.......
C=A+B
:-D
Now my problem is how can do this through Programming if Im using vb6 as frontend.
Currently I am connecting through Adodc but my knowledge is limited to
adodc1.recordsource="select......."
adodc1.refersh
adodc1.recordset.....blah blah blah
So how can I truncate/delete SC database and
merge village database into it.
I tried to make it very clear.... plz help.