Updating Records in two tables

[Matt]

Using ASP and Access is it possible for me to update recordsets in two
different tables from data collection in one page? Basically, I need
user input on 1 page that contains multiple form field areas and upon
submit it updates the records in two different tables. Any advice,
direction, or suggestions are appreciated.

thanks

[Bob Barrows [MVP]]

Matt wrote:

Using ASP and Access is it possible for me to update recordsets in two
different tables from data collection in one page? Basically, I need
user input on 1 page that contains multiple form field areas and upon
submit it updates the records in two different tables. Any advice,
direction, or suggestions are appreciated.

thanks

It's easy if you use sql statements for updates rather than recordsets.
There is nothing preventing you from executing as many sql statements as you
desire.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Matt]

On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <[e-mail]>
wrote:

Matt wrote:

Using ASP and Access is it possible for me to update recordsets in two
different tables from data collection in one page? Basically, I need
user input on 1 page that contains multiple form field areas and upon
submit it updates the records in two different tables. Any advice,
direction, or suggestions are appreciated.

thanks

It's easy if you use sql statements for updates rather than recordsets.
There is nothing preventing you from executing as many sql statements as you
desire.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

I did forget to mention that my two different tables are in two
different databases as well. Does that matter? I have a page that I
wish to pull and display data from two tables in two different
databases. Then I want my users to be able to edit the fields and
upated the records. Make sense?

[Bob Barrows [MVP]]

Matt wrote:

On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <[e-mail]>
wrote:

I did forget to mention that my two different tables are in two
different databases as well. Does that matter?

No, that doesn't matter at all. Why would it? Just open a connection to
each database and construct and run a sql statement to perform the
updates.

I have a page that I
wish to pull and display data from two tables in two different
databases. Then I want my users to be able to edit the fields and
upated the records. Make sense?

Yes. it did the first time, actually.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.