Re: 2 or more databases in one datagrid?

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

have to get the recordsets from each database and then iterate one
record at a time and add them to your grid

i have think before
but i don't know how to do that

--
http://www.letskick.net
"AGP" <sindizzy.pak@xxxxxxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:Cgx_e.842$Y_5.87@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Not with a SQL statement...at least not easily. For this you would
> have to get the recordsets from each database and then iterate one
> record at a time and add them to your grid.
>
> AGP
>
> "¢Ù¢×¢Ü¢Õ¢Ò¢Ý¢Û" <admin@xxxxxxxxxxxx> wrote in message
> news:eOFa2kCxFHA.596@xxxxxxxxxxxxxxxxxxxxxxx
>> how can it be done??
>> assumption: all databases have same tables
>> i don't know how to combine them
>> can anyone teach me??
>> i am using VB6.0
>>
>> thanks
>>
>> --
>> http://www.letskick.net
>>
>>
>
>


.

Relevant Pages

  • Re: Database has gigantic size
    ... > with the changed data. ... this then is exactly why the database grows so large. ... only a single column of the target row. ... Why were updates within recordsets so ...
    (microsoft.public.vb.database)
  • Re: Database has gigantic size
    ... DAO is simply the direct interface to JET. ... this then is exactly why the database grows so large. ... Why were updates within recordsets so ...
    (microsoft.public.vb.database)
  • Re: Any reason why accessing Access should slowdown?
    ... Using ADO with recordsets opened with 'adOpenKeyset' cursor ... App and database are all on the same machine. ... Yesterday the performance of data access became unacceptably slow, ... When the database is on a server most performance problems are related to ...
    (microsoft.public.vb.database)
  • Re: Invalid operation. (Error 3219)
    ... Action queries don't generate recordsets. ... The data engine is DAO to connect to access2003 database. ... Dim rsdb As ADODB.Recordset ... 'Public gdb As Database ...
    (microsoft.public.vb.database.dao)
  • Re: Recordset code
    ... My users are using a mde rather than a mdb. ... various recordsets. ... > issues of database corruption. ...
    (microsoft.public.access.formscoding)