Re: A simple MDB question... (OT)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: scorpion53061 (admin_at_nospampleasekjmsolutions.com)
Date: 06/11/04 

Date: Thu, 10 Jun 2004 19:34:37 -0700

It is good to see you back OHM

"One Handed Man ( OHM#)" <news.microsoft.com> wrote in message
news:#c9ce$vTEHA.556@tk2msftngp13.phx.gbl:
> You should put your question into the ADO newsgroup rather than the
> VB.NET
>
> Thanx - OHM
>
> "Anon" <anon@anon.com> wrote in message
> news:%234wJX7vTEHA.1508@TK2MSFTNGP11.phx.gbl...
> > 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
> >
> >

Relevant Pages

  • Re: A simple MDB question...
    ... You should put your question into the ADO newsgroup rather than the VB.NET ... > can just append the records from the second table into the first or vice ... > ADO connection and open another ado connection to the second MDB, ... > this record set, however, do I have to set the RS's active connection to ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ADO with Websnap in Delphi6
    ... OLEDB defines data source and ... ADO connection corresponds to OLEDB session, ...
    (borland.public.delphi.database.ado)
  • Re: How to Call MS Access Form through VB 6
    ... You can use ADO, DAO and / or RDO in this manner. ... will be able to run internal Access queries to extract tables, ... You can use the SQL that is created by Access to develop ... I am using ADO connection in VB and would like to use the same ...
    (microsoft.public.vb.general.discussion)
  • Retrieving warnings from a stored procedure in ADO (VB6)
    ... I have a ADO connection to a sybase 12.5.1 database. ... Dim strLoginInfo As String ... Set cmd = New ADODB.Command ...
    (microsoft.public.data.ado)
  • Re: ADOCommand and grave accent problem
    ... in my code to your suggestion (ie yyyy-mm-dd) but I still get the ADO error ... when using an ADO Command, and not when using an ADO Connection object. ... the ADO error still occurs with an ADO Command, not with an ADO Connection. ...
    (borland.public.delphi.database.ado)