i m using ms access and vb using ADO. i m trying to transfer few recrords
from one database to another. i m able to transfer the complete record to
another database(blank). but i cant do it if i have to transfer only few
records which is not present in the other databse(MSAccess).what i m doing
is that i m taking the recordcount of both the database . comparing it
then .

if recordcount of one database is 30 and of second is 13 .
then there is 17 data sort in other database. so i m taking the recordcount
of second database and usin that recordcount going to the record of which is
at recordcount 14 . but when i m doing it it is showing the dat which is at
recordcount 16. rs.move(13+1).
then i m moving the data to the second record.
do until rs.eof = true

with rs1
.addnew

for i = 0 to (fldcount-1)

rs1.fields(i).value = rs.fields(i).value

.update
.updateBatch
next i
but its showing the record cannot be updated as it requires a current
record . can any one please help me with that .

Archived from group: microsoft>public>vb>syntax