dbTalk Databases Forums  

Need help understanding web form / ASP / Access database etc

comp.database.ms-access comp.database.ms-access


Discuss Need help understanding web form / ASP / Access database etc in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ed
 
Posts: n/a

Default Need help understanding web form / ASP / Access database etc - 09-02-2003 , 11:41 AM






I have been trying for nearly 2 weeks to find the answer, I hope someone can
help me. Sorry it is so long, but want to give you as much info as possible.
Would even be happy to give you a copy of my very popular Graphics
Management program I re-sell worth $158 if someone can help me through this.

*** My resourses ***
I have an HTML program (Namo Web Editor) - Power user
I have access on my ISP for ASP, PHP etc - Know nothing about this
I have access to a secure server on my site - Access through FTP
I have MS Access and can create a basic database - Not a bad knowledge
I have MYOB Accounting package - Not a bad knowledge

*** My objective ***
For customers to go to my web site, place an order and 'sumit' the order
which will be stored on the secure server (credit cards). Then I would
receive an email that there is an 'Order' - I would then link to the
database through a URL to print off the order and process it. (Would *love*
to be able to inport the data into MYOB Acoounting to save me retyping
everything).
I have created a form on a web site (Name, address, phone, email, product,
payment details, credit card etc etc)

*** Questions **
The question really is, what componts do I need to build to create my
'shopping cart'?.
I just don't understand the relationship between Form, submit, MS Access,
ASP, etc.
What goes in the 'Submit' key?
What do I need to add to my HTML form for it to populate the database? (same
server on my web site).

Step by step, what do I need to do? I am very happy to do all the work if I
knew what to do.

Many thanks in advance.

Regards,

Ed



Reply With Quote
  #2  
Old   
tom
 
Posts: n/a

Default Re: Need help understanding web form / ASP / Access database etc - 09-05-2003 , 12:21 AM






Ed,

i would recommend that you go to ASP.net and download the Commerce
Starter Kit. it is a fully functional web store template build in (of
course) ASP. it is set up to use SQL Server for the backend, but you
should be able to change the connection string and point to Access
with no problem. you just need to use the Access data provider for
ADO.

the starter kits (there are several others available as well) were
architected to provide security and scalability and are very
functional. Knowing HTML will really help, and there are tutorials
there on ASP.

This should get you a good head start - and a lot easier than trying
to re-create it from scratch!

Good Luck, tom

"Ed" <bundyboy42 (AT) hotmail (DOT) com> wrote

Quote:
I have been trying for nearly 2 weeks to find the answer, I hope someone can
help me. Sorry it is so long, but want to give you as much info as possible.
Would even be happy to give you a copy of my very popular Graphics
Management program I re-sell worth $158 if someone can help me through this.

*** My resourses ***
I have an HTML program (Namo Web Editor) - Power user
I have access on my ISP for ASP, PHP etc - Know nothing about this
I have access to a secure server on my site - Access through FTP
I have MS Access and can create a basic database - Not a bad knowledge
I have MYOB Accounting package - Not a bad knowledge

*** My objective ***
For customers to go to my web site, place an order and 'sumit' the order
which will be stored on the secure server (credit cards). Then I would
receive an email that there is an 'Order' - I would then link to the
database through a URL to print off the order and process it. (Would *love*
to be able to inport the data into MYOB Acoounting to save me retyping
everything).
I have created a form on a web site (Name, address, phone, email, product,
payment details, credit card etc etc)

*** Questions **
The question really is, what componts do I need to build to create my
'shopping cart'?.
I just don't understand the relationship between Form, submit, MS Access,
ASP, etc.
What goes in the 'Submit' key?
What do I need to add to my HTML form for it to populate the database? (same
server on my web site).

Step by step, what do I need to do? I am very happy to do all the work if I
knew what to do.

Many thanks in advance.

Regards,

Ed

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.