FrontPage With Access Database

[Xcelsoft]

I have an intense Customer Service Access 2k database
that basically tracks all sorts of information for
Customer Accounts. This information is imported VIA a
satellite GPS system used by service technichans when
they visit the property.

I currently want to allow web access to certain
information stored in this database by customer account
but I don't have much web experience outside of creating
a couple of data access pages. The client has a web
server that supports ASP programming and for starters
what I am trying to do is not all that complicated just
need to get pointed in the right direction. From what I
have read, I think FrontPage should be able to handle
this.

I have two basic projects that I am trying to accomplish.

1.) Create a web page that the customer can access, login
with their account number and view certain historical
transactions about their property.

2.) Currently the Access database has a work order module
programmed into it. The customer calls the Customer
Service Dept. and the information is entered by the Rep
which creates the work order that is dispatched to a
technichan. I would like to create another web page
where a customer can access a form similar to the current
work order entry form and create their own work order.

Is FrontPage the tool I should be looking at??

Any input will be appreciated.

Xcelsoft

 

[MD Websunlimited]

See in-lines below


--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com

I have an intense Customer Service Access 2k database
that basically tracks all sorts of information for
Customer Accounts. This information is imported VIA a
satellite GPS system used by service technichans when
they visit the property.

I currently want to allow web access to certain
information stored in this database by customer account
but I don't have much web experience outside of creating
a couple of data access pages. The client has a web
server that supports ASP programming and for starters
what I am trying to do is not all that complicated just
need to get pointed in the right direction. From what I
have read, I think FrontPage should be able to handle
this.

I have two basic projects that I am trying to accomplish.

1.) Create a web page that the customer can access, login
with their account number and view certain historical
transactions about their property.

FP can not accomplish this with the tools intrinsically found in FP. You have to do some custom programming or purchase add-ins.

2.) Currently the Access database has a work order module
programmed into it. The customer calls the Customer
Service Dept. and the information is entered by the Rep
which creates the work order that is dispatched to a
technichan. I would like to create another web page
where a customer can access a form similar to the current
work order entry form and create their own work order.

You can use the Database Interface Wizard to accomplish this.

Is FrontPage the tool I should be looking at??

FrontPage can do a lot of things with a database but in special cases it requires that custom work be accomplished. So the answer
depends upon the requirements of the project and base upon your question is should work well.

 

[Peter Aitken]

I have an intense Customer Service Access 2k database
that basically tracks all sorts of information for
Customer Accounts. This information is imported VIA a
satellite GPS system used by service technichans when
they visit the property.

I currently want to allow web access to certain
information stored in this database by customer account
but I don't have much web experience outside of creating
a couple of data access pages. The client has a web
server that supports ASP programming and for starters
what I am trying to do is not all that complicated just
need to get pointed in the right direction. From what I
have read, I think FrontPage should be able to handle
this.

I have two basic projects that I am trying to accomplish.

1.) Create a web page that the customer can access, login
with their account number and view certain historical
transactions about their property.

2.) Currently the Access database has a work order module
programmed into it. The customer calls the Customer
Service Dept. and the information is entered by the Rep
which creates the work order that is dispatched to a
technichan. I would like to create another web page
where a customer can access a form similar to the current
work order entry form and create their own work order.

Is FrontPage the tool I should be looking at??

FrontPage is primarily a web design tool. For fairly complex database tasks
such as you need you will have to do some custom programming - put VBScript
code in your page to carry out the desired database actions and to display
information to users. While the newest version of FP can do some database
tasks automatically I don't think it is up to this complex a task. So yes,
FP is an appropriate tool for this task but cannot do the job alone. I
recommend looking at some reference material on ASP (Active Server Page).

 

[Xcelsoft]

Thanks Mike,

Your comments makes sense. Seems like I need to look at
FrontPage in combination with something like VBScript.

Xcelsoft

-----Original Message-----
See in-lines below


--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com


"Xcelsoft" <[email protected]> wrote

in message news:[email protected]...

FP can not accomplish this with the tools intrinsically

found in FP. You have to do some custom programming or
purchase add-ins.

You can use the Database Interface Wizard to accomplish this.

FrontPage can do a lot of things with a database but in

special cases it requires that custom work be
accomplished. So the answer

depends upon the requirements of the project and base

upon your question is should work well.

 

[Xcelsoft]

Thanks Peter,

Looks like I need to review FrontPage in combination with
VBScript.

Xcelsoft