Frontpage / Access 2002

[Guest]

I am designing a website in which I have 2 distinctive
databases. At a sign up process one of the databases
collects quite a bit of info from visitors: name, login
info, address, phones, etc. It might be possible to
insert THAT information into the shopping cart database
and this database simultaneously?

Any help will be greatly appreciated.

Claret
(e-mail address removed)

 

[Jim Buyens]

-----Original Message-----

I am designing a website in which I have 2 distinctive
databases. At a sign up process one of the databases
collects quite a bit of info from visitors: name, login
info, address, phones, etc. It might be possible to
insert THAT information into the shopping cart database
and this database simultaneously?

To physically add the data to both databases, you would
either need to modify your shopping cart software to
update the second database, or write a new app that
updated both databases. Either way, there's a risk of
interference with the shopping cart system itself.

The better alternative is usually to *link* the vendor-
supplied shopping cart database into your second
database, but only for reading. THis makes the data
available to the second application without disturbing
the shopping cart.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[clintonG]

GONG!

The first question that needs to be asked...
Who created two distinct databases and why?

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

 

[Jim Buyens]

GONG!

The first question that needs to be asked...
Who created two distinct databases and why?

I presume one came with a shopping cart application, and the other
is for a local application.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*