Front Page - Using Frontpage with an MS Access DB

Author

Using Frontpage with an MS Access DB

Neil Greenough

2004-07-29, 12:15 pm

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

2004-07-29, 7:15 pm

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)
|/---------------------------------------------------
*----------------------------------------------------