You would need to setup 3 different connection objects, then setup separate
recordsets for each of those connections.
On 03/13/00, "ASP@t..." wrote:
> I am beginning to wonder if this is possible. I have looked everywhere and
can not find any examples of what I need to accomplish.
I need a form that displays the current information contained in the
The user will then need to change and update the information.
The information is contained in two databases and three tables ((1Db &
1tbl) + (1Db & 2tbls)).
Each of the databases is on a different server.
One is an Access database and the other is SQL.
During testing I did not have any problem pulling from three different
tables in ONE database. And once I had pulled the information down I was
able to update the information using multiple Recordset objects. But when
you change the configuration everything changes.
How do you handle the Connection Object & Recordset Object when the tables
are from different databases?
How do you handle the SQL statement?
Here is a Snippet of code that is similar to what I would normally do.
' Create the Connection Object
set objConn = server.createobject("adodb.connection")
' Open the Connection using the connection string specified in the
' I normaly use DSN-Less Connections
SQL="SELECT * FROM (employee INNER JOIN clients ON employee.Empnum
clients.CLTID)" & _
"INNER JOIN tblSecurity ON clients.CLTID = tblSecurity.SECCLTID "
"WHERE Employee.Empnum= '" & CLTID & "';"
' Create RecordSet Object
set objRs = server.createobject("adodb.recordset")
' Open RecordSet Object using the SQL statement and the Connection Object
objRs.Open SQL, objConn
' ....BUNCH OF CODE TO USE THE INFORMATION
' Clean up the Recordset and Connection Object
Any ideas or even a pointer on where to look will be greatly appreciated.