Using Frontpage with an MS Access DB

[Neil Greenough]

I have a MS Access 2000 database with different prices for different items
in the database.

I am also in the middle of creating a website.

What id like is for users of my website to be able to choose two items, and
then select how many items they want, and then for a price to be given based
on the things selected by the user and comparing that with the info in the
database.

Now, is there an easy way to do this? I am using MS Frontpage 2000. Do I
need to upload my DB to the internet?

Any help would be greatly appreciated!

 

[Jim Buyens]

Responses interspersed...

-----Original Message-----
I have a MS Access 2000 database with different prices
for different items in the database.

I am also in the middle of creating a website.

What id like is for users of my website to be able to
choose two items, and then select how many items they
want, and then for a price to be given based on the
things selected by the user and comparing that with the
info in the database.

Now, is there an easy way to do this? I am using MS
Frontpage 2000.

Define "easy".

To do this sort of thing, you would almost certainly have
write your own ASP or ASP.NET program code.

Do I need to upload my DB to the internet?

Yes. This isn't usually a large issue, provided that you
either (1) make all updates via your Web site or (2) make
all updates locally. In either case, you just set up a job
in Windows Scheduler that periodically FTP's the database
from the update location to the read-only location.

If you need to update the database in both locations,
you'll probably need to do some very fancy programming.

Any help would be greatly appreciated!

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------