I have two MS Access DBs that I am using to generate data reports using SQL statement and ASP pages.
I am trying to use two different databases, one is an archived database and the other is the current database. The fields have exactly the same names and are TEXT fields.
How do I open two databases, to pull the data from, at the same time. Currently I am using an inc file to open ONE database and that works fine, but how do I open the 2nd database. I will include my inc file.