[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.frontpage.programming

FrontPage With Access Database

=?Utf-8?B?cm9kY2hhcg==?=

4/14/2004 12:24:00 AM

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
4 Answers

Greg Chagnon

4/14/2004 11:16:00 AM

0

See in-lines below


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


"Xcelsoft" <anonymous@discussions.microsoft.com> wrote in message news:1c6d701c421b6$d1a7dc20$a101280a@phx.gbl...
> 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.

>
> Any input will be appreciated.
>
> Xcelsoft

Peter Aitken

4/14/2004 12:24:00 PM

0

"Xcelsoft" <anonymous@discussions.microsoft.com> wrote in message
news:1c6d701c421b6$d1a7dc20$a101280a@phx.gbl...
> 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).


--
Peter Aitken

Remove the crap from my email address before using.

=?Utf-8?B?cm9kY2hhcg==?=

4/14/2004 4:05:00 PM

0

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.websunl...
>
>
>"Xcelsoft" <anonymous@discussions.microsoft.com> wrote
in message news:1c6d701c421b6$d1a7dc20$a101280a@phx.gbl...
>> 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.
>
>>
>> Any input will be appreciated.
>>
>> Xcelsoft
>
>
>.
>

=?Utf-8?B?cm9kY2hhcg==?=

4/14/2004 4:08:00 PM

0

Thanks Peter,

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

Xcelsoft

>-----Original Message-----
>"Xcelsoft" <anonymous@discussions.microsoft.com> wrote
in message
>news:1c6d701c421b6$d1a7dc20$a101280a@phx.gbl...
>> 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).
>
>
>--
>Peter Aitken
>
>Remove the crap from my email address before using.
>
>
>.
>