This is what I try to make:
 
I would like to give our employees the opportunity to fill in a HTML
form (to be created in Dreamweaver) and send (store) the data to the
shared networkdirectory.

Once this is done, the data should be automatically imported in an Access
database and after succesfull import the sent data must be deleted
automatically.
 
So generally it is about sending data (via HTML) to an Access 97
database.
 
Anyone solved this problem before?
Who can help me? What do I need to solve this issue?
 
Kind regards,
 
Luc

Hi, 

I'm going to show you some solutions for this in PHP, not because Perl
would not be better or you couldn't do it, but it appears you aren't
very filmier with CGI setups and Perl would require this. PHP for this
type of thing is just as good, and takes less on the server side setup
to get done. That's assuming that PHP is installed on your Internet
Server. Since you bring it up I'm going to assume it is.

First you will set up the form and have it POST to the PHP page that
will take in the data. This is easy to do, in your <FORM> tag you will
say that the Action is the PHP page and the method is POST.

The PHP page will then record the data entered in a text file on the
server. Use a comma delimited format that matches your Access database
and you won't have any trouble there. Also the PHP page will have the
download option, which will download the current entries, copy the
existing file to a backup file and clear the existing data for new
entries. You will want to do the import and clearing when the data
entry people are not using the program. Lunch Period, and after hours
is good. The reason is that you don't want the few moments of clearing
and download to take out one of the entries.

This is really simple PHP programming and with a bit of study and
testing you will probably pick it right up.

Here are some links you want to start off with that will give you some
demos on how to do this.

HotScrips.com PHP Form Processors
http://www.hotscripts.com/PHP/Scripts_and_Programs/Form_Processors/more3.html

Total Scripts.com PHP Form Processors
http://www.totalscripts.com/pages/PHP/Scripts_and_Programs/Form_Processors/

PHP : File I/O
http://www.cs.swt.edu/~rs01/2378i/php/fileio/spiel.htm


ASP Solutions -- Since those were mentioned I'll put a few links for
this solution as well on here.

ASP: Writeto comma delimited file
http://www.intranetjournal.com/ix/msg/14241.html


And this is just something fun that you can play with and learn more
about what and how you are doing this. Its in ASP
http://www.eggheadcafe.com/articles/20010414.asp



Other links of interest

PHP Main Site
http://www.php.net


Google Queries
PHP +Form +"Comma Delimited File"
+ASP +Form +"Comma Delimited File" +Access

Thanks,

webadept-ga

Use ASP(ASP.NET) or Coldfusion.HTML is hyper text language and doesnt
have ability to add anything to database.Scripting can insert data to
database.
If you more familiar with unix then use Perl or PHP

Dear gerasha-ga,

I need a more specific answer. Yes, I am more familiar with Unix and
yes, I want to use Perl or PHP.

Which specific CGI-script(s) do you suggest for this purpose?

I had no knowledge of php or cgi scripts but from what I have seen of
them, they look like C++....and you know it takes a long time to
develop applications using c++ unless you got stable foundation
classes you can use.  I suggest you do it the easier way. Simply make
an activex control and embed it in your html page.  Make the control
Visual Basic.  This solution works for IE browsers only but you can do
the whole thing in under 3 hours.  You can even put your validation
logic inside the control and it is very light on server resources.  If
you have more questions you can email at jpalmera@heritagepark.com.ph
as I am very bored right now and had nothing to do.

Won't access let you save a form as a web page?  If you know access,
create the form there, and save it as a web page.  That process should
build in the connection between your (now) html form and the access
db.