Insert record from one db to another db

Report · Jan 11, 2007

Hi all,

need to retrieve a record from a table using varID (tblBookingForm) in one
database and insert in into another table (tblNetServ) in another database
on the same server, leaving the original record where it came from. Cant get
my head round it though MX doesn't seem to allow for 2 active connections.

Anyone help?

Regards
Simon

--
Simon Gare
The Gare Group Limited

website: www.thegaregroup.co.uk
website: www.privatehiresolutions.co.uk

Report · Jan 11, 2007

On Fri, 12 Jan 2007 04:54:42 -0000, "Simon Gare" <sg@simongare.com>
wrote:

>Hi all,
>
>need to retrieve a record from a table using varID (tblBookingForm) in one
>database and insert in into another table (tblNetServ) in another database
>on the same server, leaving the original record where it came from. Cant get
>my head round it though MX doesn't seem to allow for 2 active connections.
>
>Anyone help?
>
>Regards
>Simon

How about:

retrieve the value from the first database

save it into a session variable

stuff the value of the session variable into the second database

Win
--
Win Day, Wild Rose Websites
http://www.wildrosewebsites.com
winday@NOSPAMwildrosewebsites.com
Skype winifredday

Report · Jan 12, 2007

Which database are you using?

If it is Access then I would say you will to use a method similar to the one
Win suggested or invent another crafty way. If you are using SQL Server then
you can use a Linked Server.

Without the type of database it is very difficult to offer help.

"Simon Gare" <sg@simongare.com> wrote in message
news:eo74c1$152$1@forums.macromedia.com...
> Hi all,
>
> need to retrieve a record from a table using varID (tblBookingForm) in one
> database and insert in into another table (tblNetServ) in another database
> on the same server, leaving the original record where it came from. Cant
> get
> my head round it though MX doesn't seem to allow for 2 active connections.
>
> Anyone help?
>
> Regards
> Simon
>
> --
> Simon Gare
> The Gare Group Limited
>
> website: www.thegaregroup.co.uk
> website: www.privatehiresolutions.co.uk
>
>