What program/ How to link Website fill in form

[petrovlis]

I work with msAccess2000 and like to make a
link from my Website ,sothat client fill in their
address details ( or whatever) sothat, my database
"Address" is filled with clients input.
It should be secured that they cannot see/hack the
Address database.
Also: that client can fill in product,quantity
and destination sothat client gets immedaite a quote
for that destination.
I have product,address,and freight tables.
Thanks for any hint/reference to such an existing
program.
William Rippen

 

[GUJUm0deL]

petrovlis, you have to use some kind of server-side langaue to accomplish this. Either Coldfusion, ASP, PHP, etc. As far as securoty is concerned that depends on the two things: coding from server-side scripts, and hosting company.

[sub]
____________________________________
Just Imagine.

http://www.imajinarts.com

[sub]

 

[pixl8r]

Yes. Personally I wouldn't data drive a newsletter, but you could if you wanted to.

The thing is you can do practically anything you want to do with the data. You really need to talk to the individual(s) who will be doing the development for you. The fancier the web site the more expensive. It takes a lot of code to accomplish highly dynamic and interactive web sites.

One thing to consider... Access 2000 is not built for high web traffic. You will need to switch to a more robust DB like SQL or MySQL.

Wow JT that almost looked like you knew what you were doing!

 

[audiopro]

If the amount of data is quite small you could use simple text files and manipulate the data from a server side language. We have some quite large text files working in this way with no problems at all.
The security issue is a different story.
The beauty of server side scripting is that variables within the script are invisible to outside users so the worst damage any visitor can do is to place junk data on your site.

Keith

http://www.studiosoft.co.uk

 

[MikeBarone]

To write to Access you will need ODBC and know how to port the data to the database using ODBC. This will require you to have a working relationship with your hosting company. Not a very common thing to find, a hosting company willing to work with newbies on database manipulation.

I would investigate off the shelf programs that will get you the data you are looking for. Many form processing applications (CGI, PHP, ASP, etc.) will save the data into a tabulated flat file database. You can setup a link to this file for your customer. Any time they want an update they can click the link, download the file, and import it into Access.

Mike Barone

http://www.cgiscript.net

FREE CGI/Perl Scripts & JavaScript Generators