Get data from several Access and SQL Server databases

[FesterSXS]

Hi,

I have also posted this question in the SQL Programming forum (forum183)

I would like to create a recordset built from data from a number of SQL Server 2000 databases and also several Access databases. All databases are running on the same server.

To put my problem into context, I am trying to show news articles on our International website. I would like to query the database of each of our National websites for any news articles that they have. I would then like to order all of these news articles by date and show them on one page (ASP). Some of these sites use Access DBs and some use SQL Server.

The News tables in the various Access databases all have the same structure and likewise, the News tables in the various SQL Server databases all have the same structure.

Anyone have any ideas?

Thanks

Tony
---------------------------------------

http://www.SpiraxSarco.com/