Y need to query a UNION of 2 tables with the same name and same structure 

but stored in 2 different Access database files.



table #1   (table name='Customers')  database file: c:\data\year1999.mdb

table #2   (table name='Customers')  database file: c:\data\year2000.mdb



¿How do I build the propper connection and recordset?



Please Help me...





Thank you



G.Valle Kattendahl 

No se si ya te han resuelto el problema pero creo que vas a tener un

serio problema en la estructura de tu base de datos, te recomendaria que

las unieras y manejara campo por fechas



DHR.



(Translated by Babelfish - 



 If already they have solved to you the problem but I do not believe 

that you are going to have a serious problem in the structure of your 

data base, recomendaria you that you united them and handled field 

per dates )



-----Mensaje original-----

De: Gregorio Valle Kattendahl [mailto:2vasos@t...]

Enviado el: Viernes 7 de Septiembre de 2001 06:20 PM

Para: ASP_ADO_RDS

Asunto: [asp_ado_rds] ADO SQL UNION from 2 Access *.mdb





Y need to query a UNION of 2 tables with the same name and same

structure

but stored in 2 different Access database files.



table #1   (table name=3D'Customers')  database file: 

c:\data\year1999.mdb

table #2   (table name=3D'Customers')  database file: 

c:\data\year2000.mdb



=BFHow do I build the propper connection and recordset?



Please Help me...





Thank you



G.Valle Kattendahl