Prepairing Web Site

J

John Phelan

I have two forms:

1. Registration Form for a Forum Area that ask for basic information,
2. A Signup Form for a Download Software Area that asked for mor detail
information.

There is some minimu information that is the same on both forms, i.i., name,
address, etc. I am using a sepparate Conformation form, of course, for each.


My question is; do I use the same back-end Access database for each form, or
do I create a separate one; one for Registration, and one for the Download
area.

What are the advantages and disadvantages?
If its turns out that I should only one database; can I still use separate
confirmation forms?

John Phelan
 
J

Jim Buyens

Responses interspersed...
-----Original Message-----
I have two forms:

1. Registration Form for a Forum Area that ask for basic
information,
2. A Signup Form for a Download Software Area that asked
for mor detail information.

There is some minimu information that is the same on both
forms, i.i., name, address, etc. I am using a sepparate
Conformation form, of course, for each.

My question is; do I use the same back-end Access
database for each form, or do I create a separate one;
one for Registration, and one for the Download area.
Click to expand...

Either approach will work, but I recommend using two
different tables in the same database.
What are the advantages and disadvantages?
Click to expand...

Thge advantage of using one database is that it's easier
to download, and it's easier to match the two tables
against each other.
If its turns out that I should only one database; can I
still use separate confirmation forms?

John Phelan
Click to expand...

Yes.

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

Mark Fitzpatrick

John,
As you've already had some good ansewrs, I'll just add one thing.
You may want to use two different Access databases. MS Access performance
degrades significantly whith multiple connections. Usually though, the most
degredation usually occurs during update/insert/delete operations and not so
much a select operation. Having them in two databases may avoid some issues,
especially if you have a number of users writing to the forum. This could
disperse some of the user login and registration load onto one db and the
actual forum info to another. Normally it's best to have them both in one
for convenience sake and to make certain operations easier, but with the
issues of Access to consider, sometimes it's helpful in the long-run to be a
little paranoid about potential problems.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage
 
A

Andrew Murray

that's three times you've posted the same question! is something wrong with your
news reader?

the answer is yes, you can use different databases for each form, or the same
database for all forms with separate confirmation pages for each form.
 
Top