Updating Records in two tables - Inetserver

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"

On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
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?

Matt wrote:
> On Feb 22, 6:34 pm, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
> 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.