Multiple Recordsets for Allbase and Access

Results 1 to 2 of 2

Thread: Multiple Recordsets for Allbase and Access

  1. #1
    Join Date
    Dec 1969

    Default Multiple Recordsets for Allbase and Access

    Hi! friends,<BR><BR>I have two databases one is a remote database say &#039;X&#039; (Allbase) having DSN "xxx" and second database (Access2000) in local computer say &#039;Y&#039; having DSN "yyy" . I want to run a query like <BR> " INSERT INTO LOCAL SELECT * FROM REMOTE " . So I need two Connection Objects (conRemote and conLocal)and two Recordset objects (RsRemote,RsLocal)....can anyone tell me the exact way of doing I am getting some funny errors....what I mean is can you tell me the syntax...which connection and recordset should come after which and where and when to write the query.and weather the connections need to be closed or to remain open when the other is open.<BR><BR>Thanks & Rgds<BR>Nilabdhi<BR><BR>

  2. #2 Guest

    Default No way!

    It does not work like that, because the two databases have to be accessed by two separate connections. When you open a recordset on a connection, that connection cannot see the tables in the other database. <BR><BR>You can of course, issue sql commands to read data from one database, and separate sql commands to insert that data into the other database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts