A simple MDB question...

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

Hello All!
I am trying to merge two tables from two different MDB's into one. I know I
can just append the records from the second table into the first or vice
versa, which will suffice in my situation, however, I'm not sure what the
the correct way to do it.
here i smy thinking on it, generate a rs from the second table, close the
ADO connection and open another ado connection to the second MDB, and append
this record set, however, do I have to set the RS's active connection to the
new connection?

TIA
Luis
 
You should put your question into the ADO newsgroup rather than the VB.NET

Thanx - OHM
 
Hi Anon,

In addition from OHM,

microsoft.public.data.ado

is an Ado newsgroup.

Cor
 
It is good to see you back OHM

One Handed Man ( OHM#) said:
You should put your question into the ADO newsgroup rather than the
VB.NET

Thanx - OHM
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONNECT MDB FILE FROM ADP FILE 12
ADO to mdb joins 3
Monitoring MS-Access (mdb) changes 2
Merge multiple mdb files 17
Is ACCDB faster than MDB using JDBC Bridge Connection for Java? 2
CSV file as database 12
check existing connections to a .MDB file 4
Syntax when setting ado rs or conn timeout (not adp) 2

Back
Top