access project and multiple SQL backends HELP

[Guest_imported]

I want to have concurrent connections to 2 different SQL backends.

Right now the tables I need form a project from one database is push replicated to the 2nd database that really is the core of the project Im writting.

the problem is the delay of replication and read only because of the replication id column in the replicated columns.

If there is a way to have a form that has two concurrent connections open to 2 different databases that isn's just using select and update sql statements, but real binding I would be eternally greatfull to any one with an solution.

 

[Terpsfan]

If you create a connection to your SQL backends you can create a connection via ADO to more than one database. Give this a try and see if it works.

Dim objConn as ADODB.Connection
Dim objConn1 as ADODB.Connection
Set objConn = New ADODB.Connection
Set objConn1 = New ADODB.Connection

objConn.Open "Provider = SQLOLEDB.1 Data Source = SQLServername; Initial Catalog = databasename....etc"

objConn1.Open "Provider = SQLOLEDB.1 Data Source = SQLServername; Initial Catalog = databasename....etc"

Set field1.DataSource = objConn
field1.DataField = "Fieldname"
Set field1.DataSource = objConn1
field1.DataField = "Fieldname"