Two database file

[Dilruba]

I am using one databse file for my website. such as data1.mdb

Is there any option to use another database file for the same website such as data2.mdb

In a conclusion, i want to say that my website will access two database file at a time. such as data1.mdb and data2.mdb

Please help me

[jhardman]

this is not a problem, you just need to have two different adodb connections. For example:

dim objConn1, objConn2
set objConn1 = server.createObject("adodb.connection")
objConn1.Provider="Microsoft.Jet.OLEDB.4.0"
objConn1.Open "c:/inetpub/myDBFiles/data1.mdb"
set objConn2 = server.createObject("adodb.connection")
objConn2.Provider="Microsoft.Jet.OLEDB.4.0"
objConn2.Open "c:/inetpub/myDBFiles/data2.mdb"

Jared