Multiple Database Connections

Topic

New Reply

Is it possible for one ASP page to open connections to two different Access databases at the same time?

I need to update similar data in two different databases from the same data entry form.

Reply | Quote

Replies

Yes – you can easily do this. You can either create a second connection object, or simply declare the database location in the second recordset’s parameters.

Recordset 1 uses the first method (with the Connection object) and Recordset 2 uses the second method (no connection object) – you can mix and match as you like. Of course, Server overhead is probably lower with fewer objects…

HTH

Reply | Quote

Thanks.

Since this situation will not occur on a regular basis, I went with creating two connections.

It worked perfectly.

Reply | Quote