using Access database with FP2003

N

newbie

I'm starting an online store and I have many products and, therefore, many
prices to keep track of. I have all my products, prices, etc stored in an
Access database and I have already made the database connection with my site.

Is there any way I can grab a specific price from my database and display it
for a specific product on the product page in the website?

So, in other words, is there a way I can type all my prices into my
database, then have the prices on my website automatically update according
to the changes I made in the database?
 
T

Thomas A. Rowe

Yes. However, are you planning just to have a online catalog of products and prices or do you plan
to let customer actually purchase products online from the catalog?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
N

newbie

Yes, the items on my website will be for sale; and I already have a shopping
cart program set up and everything. My database is already full of products,
but I'm not even close to being finished with entering all my products.

How do I go about setting up the database so I can simplify price-changing?
 
S

Stefan B Rusynko

If you don't know how to hand code ASP and are using the DBRW see http://home.att.net/~codelibrary/FrontPage/drw.htm
If you know how to hand code ASP see
http://www.w3schools.com/asp/default.asp
and examples at http://www.asp101.com/samples/

PS
If you are asking such basic questions as how to edit your DB thru the browser
- good luck on setting up the shopping cart to use your DB

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Yes, the items on my website will be for sale; and I already have a shopping
| cart program set up and everything. My database is already full of products,
| but I'm not even close to being finished with entering all my products.
|
| How do I go about setting up the database so I can simplify price-changing?
|
|
|
| "Thomas A. Rowe" wrote:
|
| > Yes. However, are you planning just to have a online catalog of products and prices or do you plan
| > to let customer actually purchase products online from the catalog?
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > I'm starting an online store and I have many products and, therefore, many
| > > prices to keep track of. I have all my products, prices, etc stored in an
| > > Access database and I have already made the database connection with my site.
| > >
| > > Is there any way I can grab a specific price from my database and display it
| > > for a specific product on the product page in the website?
| > >
| > > So, in other words, is there a way I can type all my prices into my
| > > database, then have the prices on my website automatically update according
| > > to the changes I made in the database?
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top