Updating two databases in two places

[n0795]

I use this code to update a database with an email address,I would like to update a different database using the same form so the users do not have to do it twice.
The other database is on E but not in test its in the root of my site and its called users.mdb
Response.Buffer = true
dim cnn,rst
set cnn = Server.CreateObject("ADODB.Connection&quot
set rst = Server.CreateObject("ADODB.RecordSet&quot
cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=E:/Test/testdatabase.mdb;"
sqltext = "SELECT * FROM Testdatabase"
rst.Open sqltext,cnn,3,3

dim Email
Email = Request.Form("Email&quot
if Email = "" then
error = "You have not entered an Email address.please click back"
Response.Write error
Response.End
end if

rst.AddNew
rst("Email&quot = Email
rst.update

%>

 

[vasah20]

two different access databases takes two different connections. Just create another connection to the other DB, then issue the same SQL query.

Although -- you might want to look into linking tables... I don't have a lot of experience with it, but it might work in your situation.

hth
leo