Can I UPDATE 2 tables with one ADODB

Discussion in 'Databases' started by tcampb, Feb 12, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. tcampb

    tcampb

    I have a manage your accountform for customers. Some of the info resides in one table and some in another. Can I do the following:



    Set Conn = Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open "e:\mywebspace\db1.mdb
    conn.execute = "UPDATE Cust_hdr SET brokerage='"&broker&"', broker_phone='"&br_phone&"', a_name='"&agent&"', home_phone='"&a_phone&"' WHERE acct_no = '"&account&"'"
     
    tcampb, Feb 12, 2005
    #1
  2. tcampb

    tcampb

    I figured I would just try it and shazzamm! it worked.
     
    tcampb, Feb 12, 2005
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page