How do I tell my script I want to use more than one data source.
Data Source 1 = sFeinNum (fein table from Expense DB)
Data Source 2 = sAccounts (account table from the Expense DB)

How do I change this bit of code to include both sFeinNum and sAccounts?

Set connect = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateOBject("ADODB.Recordset")
connect.ConnectionString = _
  "Provider=Microsoft.Jet.OLEDB.4.0;" & _
  "Data Source=" & sFeinNum
connect.open

Big mistake in my message

Data Source 1 = sFeinNum (fein table from FEIN DB)
Data Source 2 = sAccounts (account table from Account DB)

Or is the problem with this piece of code:

<%
Dim sFeinNum
sFeinNum = "F:\dbs\fein.mdb"
sAccount ="F:\dbs\Expense.mdb"
%>


Should I use one Data Source for both databases? How do I do that?

What is it that you need to accomplish? Are you trying to do a JOIN on two databases?

If that's the case, AFAIK that cannot be done with an Access database and ADO.

If you need to join the data anyway, I think they only way is to get two local Recordsets, copy their contents to an array, and build some JOINing logic yourself.

If this is not what you want, please describe your situation in some more detail.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.