It all depends on whether you all want it done automatically or not.  And
whether you want to put your database online (which means the offline
version and online version need to be synchronised).  And in extremis if you
want to pay for this feature or not (you'll need ASP/PHP/... to approach
databases on a website).

If you website isn't too busy, your server is rightly configured and your
access relations and ASP/PHP/... scripts are correctly written, an Access
database will do the job.  Just don't think it will be able to handle tens
of thousands of records.

Some examples:
www.enetdesigners.co.uk/fiatcoupe (the thing you need: list of people with
Access database)
www.enetdesigners.co.uk/fiatcoupe/chatnew (an ASP chat with Access database)
www.fiatcoupe.net/chat (working on the PHP chat with MySQL database)

Alternatively, you *could* do some tricks that will require manual checking
(which could be good or bad).  You could for example work on your email form
so that it produces a comma (or semi-column) separated list of the things
you wish to insert in your database, or (what I would probably do) even
generate an SQL string (or even both) so that you can just copy and paste it
into the SQL control of Access.

If you don't want to work with a database, there's always the possibility of
a flat text file (again, comma separated for example).  So that you don't
have to submit each person individually, but you can just wait until a nice
amount has 'subscribed' and then import it into Access in one go.

All different solutions, they all have their advantages and prices.


- Kayjey -
www.fiatcoupe.net


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

I was wondering... There must be a way so that they can easily and 
automatically grab the data for new members and feed it into their 
database, no?

I would very much appreciate if you could give me any advice on how 
this can be done. I do not need a detailed explanation. A general 
idea will be enough.

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA