DB structure for a company store being put on an Intranet.

[Curnzy]

I am currently developing a web site for a company store. They lady Im developing the site for wants to be able to update the site herself and weekly special offers, so I need to develop a database that stores all the different prices, sizes, colours, styles etc. There are a large amount of products and I'm not sure what fields I should use in what tables. Please, if anybody has a few ideas or knows how small e-commerce sites set up their dbs, let me know.
Thanks,
Curnzy

 

[DougP]

I would use Front Page 2000
You can create an Access 2000 database right on the WEB site
The site has to be on an NT server though, With Front Page 2000 Server extensions.
Front Page has wizards to do the whole thing.
Once the Access database is created it is just like any other Access database. You can create macros and so on. Forms or whatever.

Make the WEB pages .ASP pages to let customers do their thing. Front Page has wizards for this too

Then you can make a Icon on her desktop that lets her open the database just like any other.
She needs Access though.

Or if you make an .ASP page for her that has a password, then she can log in and update whatever.

here is one for My WEB site

http://www.barcodeone.com/tellusaboutyou.asp

This is saving the data to an Access database when you hit submit.

here is the Access database looking from My PC after I clicked the Icon I created.

http://www.barcodeone.com/screen_capture.htm

this is the link on my desktop to launch the Access database.

http://www.mysite.com/xxxx/yyyy/mydata.mdb

The names have been changed to protect the innocent.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[JHoarty]

Curnzy:

Feel free to download the documentation for QuickEStore at

http://www.quickestore.com/readme.doc.

This Word document has the complete database layout including fields, table relationships, etc., in a series of screenshots at the end. It's an 18 page document that describes in detail how QuickEStore works.

I hope it helps.

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com