PC Review


Reply
Thread Tools Rate Thread

Database from form--how to retrieve

 
 
Mata Stevenson
Guest
Posts: n/a
 
      21st May 2005
Hi helpers,

I'm creating my first database in FP 2002 to collect data from a form
and would like to know how the organization I'm doing this for will
retrieve the data. Will they log in to the site every day, open the fpdb
folder, then export the .mdb file to their drive, and work on it there,
setting up the report, etc.? I'm not too familiar with Access, and
they're not too adept with the computer in general, so hoping it will be
easy.

Thanks in advance, Mata


 
Reply With Quote
 
 
 
 
Andrew Murray
Guest
Posts: n/a
 
      22nd May 2005
Use the Database results wizard in frontpage.

"Mata Stevenson" <(E-Mail Removed)> wrote in message
news:uh$(E-Mail Removed)...
> Hi helpers,
>
> I'm creating my first database in FP 2002 to collect data from a form and
> would like to know how the organization I'm doing this for will retrieve
> the data. Will they log in to the site every day, open the fpdb folder,
> then export the .mdb file to their drive, and work on it there, setting up
> the report, etc.? I'm not too familiar with Access, and they're not too
> adept with the computer in general, so hoping it will be easy.
>
> Thanks in advance, Mata
>



 
Reply With Quote
 
Mata Stevenson
Guest
Posts: n/a
 
      22nd May 2005
I was hoping the organization could access and use the .mdb file I
create in the fpdb directory without using FP. Can they not do that?

One other question: is it true that if I have the form input results go
to a database, that they can't be emailed as well, as they can be if I
have the results stored in html?

Thanks, Mata

"Andrew Murray" <(E-Mail Removed)> wrote in message
news:42901228$0$24863$(E-Mail Removed)...
> Use the Database results wizard in frontpage.
>
> "Mata Stevenson" <(E-Mail Removed)> wrote in message
> news:uh$(E-Mail Removed)...
>> Hi helpers,
>>
>> I'm creating my first database in FP 2002 to collect data from a form
>> and would like to know how the organization I'm doing this for will
>> retrieve the data. Will they log in to the site every day, open the
>> fpdb folder, then export the .mdb file to their drive, and work on it
>> there, setting up the report, etc.? I'm not too familiar with Access,
>> and they're not too adept with the computer in general, so hoping it
>> will be easy.
>>
>> Thanks in advance, Mata
>>

>
>



 
Reply With Quote
 
Ronx
Guest
Posts: n/a
 
      22nd May 2005
As Andrew said - use the FrontPage Database Results Wizard.
This generates pages that allows your organisation to view the records
in the database using web pages.
The Database Interface Wizard (FP2002 and FP2003) will allow your
organisation to additionally edit and add records to the database,
again using web pages.

The only other way to access the database is to download it. The web
would have to be effectively disabled while the database is being
updated.
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

"Mata Stevenson" <(E-Mail Removed)> wrote in message
news:uY$(E-Mail Removed)...
>I was hoping the organization could access and use the .mdb file I
>create in the fpdb directory without using FP. Can they not do that?
>
> One other question: is it true that if I have the form input results
> go to a database, that they can't be emailed as well, as they can be
> if I have the results stored in html?
>
> Thanks, Mata
>
> "Andrew Murray" <(E-Mail Removed)> wrote in message
> news:42901228$0$24863$(E-Mail Removed)...
>> Use the Database results wizard in frontpage.
>>
>> "Mata Stevenson" <(E-Mail Removed)> wrote in message
>> news:uh$(E-Mail Removed)...
>>> Hi helpers,
>>>
>>> I'm creating my first database in FP 2002 to collect data from a
>>> form and would like to know how the organization I'm doing this
>>> for will retrieve the data. Will they log in to the site every
>>> day, open the fpdb folder, then export the .mdb file to their
>>> drive, and work on it there, setting up the report, etc.? I'm not
>>> too familiar with Access, and they're not too adept with the
>>> computer in general, so hoping it will be easy.
>>>
>>> Thanks in advance, Mata
>>>

>>
>>

>
>



 
Reply With Quote
 
Ronx
Guest
Posts: n/a
 
      22nd May 2005
The FrontPage DRW cannot also send emails. You can, however, write
your own scripts to update the database and send emails.
See http://www.interlacken.com/winnt/tip...ow.aspx?tip=54 for an
example.
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

"Mata Stevenson" <(E-Mail Removed)> wrote in message
news:uY$(E-Mail Removed)...
>I was hoping the organization could access and use the .mdb file I
>create in the fpdb directory without using FP. Can they not do that?
>
> One other question: is it true that if I have the form input results
> go to a database, that they can't be emailed as well, as they can be
> if I have the results stored in html?
>
> Thanks, Mata
>
> "Andrew Murray" <(E-Mail Removed)> wrote in message
> news:42901228$0$24863$(E-Mail Removed)...
>> Use the Database results wizard in frontpage.
>>
>> "Mata Stevenson" <(E-Mail Removed)> wrote in message
>> news:uh$(E-Mail Removed)...
>>> Hi helpers,
>>>
>>> I'm creating my first database in FP 2002 to collect data from a
>>> form and would like to know how the organization I'm doing this
>>> for will retrieve the data. Will they log in to the site every
>>> day, open the fpdb folder, then export the .mdb file to their
>>> drive, and work on it there, setting up the report, etc.? I'm not
>>> too familiar with Access, and they're not too adept with the
>>> computer in general, so hoping it will be easy.
>>>
>>> Thanks in advance, Mata
>>>

>>
>>

>
>



 
Reply With Quote
 
=?Utf-8?B?Z3VpZG8=?=
Guest
Posts: n/a
 
      22nd May 2005
Ronx,

good explanation! thanks for also helping me.
Have a question too, which i allready have a thread for, but anyway.
Have FP 2003, creating a databased website, created Resultsform, database
editor and submitform.
After filled in submitform, upon clicking submit, i get the error that the
job has failed and i should contact the server-host if the problem keeps
occurring..
I know i do something wrong, but what? i'm going nuts with this.

Thanks for giving me an answer.

"Ronx" wrote:

> The FrontPage DRW cannot also send emails. You can, however, write
> your own scripts to update the database and send emails.
> See http://www.interlacken.com/winnt/tip...ow.aspx?tip=54 for an
> example.
> --
> Ron Symonds
> Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
>
> "Mata Stevenson" <(E-Mail Removed)> wrote in message
> news:uY$(E-Mail Removed)...
> >I was hoping the organization could access and use the .mdb file I
> >create in the fpdb directory without using FP. Can they not do that?
> >
> > One other question: is it true that if I have the form input results
> > go to a database, that they can't be emailed as well, as they can be
> > if I have the results stored in html?
> >
> > Thanks, Mata
> >
> > "Andrew Murray" <(E-Mail Removed)> wrote in message
> > news:42901228$0$24863$(E-Mail Removed)...
> >> Use the Database results wizard in frontpage.
> >>
> >> "Mata Stevenson" <(E-Mail Removed)> wrote in message
> >> news:uh$(E-Mail Removed)...
> >>> Hi helpers,
> >>>
> >>> I'm creating my first database in FP 2002 to collect data from a
> >>> form and would like to know how the organization I'm doing this
> >>> for will retrieve the data. Will they log in to the site every
> >>> day, open the fpdb folder, then export the .mdb file to their
> >>> drive, and work on it there, setting up the report, etc.? I'm not
> >>> too familiar with Access, and they're not too adept with the
> >>> computer in general, so hoping it will be easy.
> >>>
> >>> Thanks in advance, Mata
> >>>
> >>
> >>

> >
> >

>
>
>

 
Reply With Quote
 
Ronx
Guest
Posts: n/a
 
      22nd May 2005
Contact your host and check the server http server logs, error logs
and event logs.
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

"guido" <(E-Mail Removed)> wrote in message
news:BB0CDEEE-4AD6-41AE-8E20-(E-Mail Removed)...
> Ronx,
>
> good explanation! thanks for also helping me.
> Have a question too, which i allready have a thread for, but anyway.
> Have FP 2003, creating a databased website, created Resultsform,
> database
> editor and submitform.
> After filled in submitform, upon clicking submit, i get the error
> that the
> job has failed and i should contact the server-host if the problem
> keeps
> occurring..
> I know i do something wrong, but what? i'm going nuts with this.
>
> Thanks for giving me an answer.
>
> "Ronx" wrote:
>
>> The FrontPage DRW cannot also send emails. You can, however, write
>> your own scripts to update the database and send emails.
>> See http://www.interlacken.com/winnt/tip...ow.aspx?tip=54 for
>> an
>> example.
>> --
>> Ron Symonds
>> Microsoft MVP (FrontPage)
>> Reply only to group - emails will be deleted unread.
>>
>> "Mata Stevenson" <(E-Mail Removed)> wrote in message
>> news:uY$(E-Mail Removed)...
>> >I was hoping the organization could access and use the .mdb file I
>> >create in the fpdb directory without using FP. Can they not do
>> >that?
>> >
>> > One other question: is it true that if I have the form input
>> > results
>> > go to a database, that they can't be emailed as well, as they can
>> > be
>> > if I have the results stored in html?
>> >
>> > Thanks, Mata
>> >
>> > "Andrew Murray" <(E-Mail Removed)> wrote in message
>> > news:42901228$0$24863$(E-Mail Removed)...
>> >> Use the Database results wizard in frontpage.
>> >>
>> >> "Mata Stevenson" <(E-Mail Removed)> wrote in message
>> >> news:uh$(E-Mail Removed)...
>> >>> Hi helpers,
>> >>>
>> >>> I'm creating my first database in FP 2002 to collect data from
>> >>> a
>> >>> form and would like to know how the organization I'm doing this
>> >>> for will retrieve the data. Will they log in to the site every
>> >>> day, open the fpdb folder, then export the .mdb file to their
>> >>> drive, and work on it there, setting up the report, etc.? I'm
>> >>> not
>> >>> too familiar with Access, and they're not too adept with the
>> >>> computer in general, so hoping it will be easy.
>> >>>
>> >>> Thanks in advance, Mata
>> >>>
>> >>
>> >>
>> >
>> >

>>
>>
>>



 
Reply With Quote
 
MikeR
Guest
Posts: n/a
 
      23rd May 2005
ASP ? If the host supports it.
MikeR
Ronx wrote:
> The only other way to access the database is to download it. The web
> would have to be effectively disabled while the database is being
> updated.

 
Reply With Quote
 
Bob Lehmann
Guest
Posts: n/a
 
      24th May 2005
Careful.....
guido might think you're a smart-ass.

Bob Lehmann

"Ronx" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Contact your host and check the server http server logs, error logs
> and event logs.
> --
> Ron Symonds
> Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
>
> "guido" <(E-Mail Removed)> wrote in message
> news:BB0CDEEE-4AD6-41AE-8E20-(E-Mail Removed)...
> > Ronx,
> >
> > good explanation! thanks for also helping me.
> > Have a question too, which i allready have a thread for, but anyway.
> > Have FP 2003, creating a databased website, created Resultsform,
> > database
> > editor and submitform.
> > After filled in submitform, upon clicking submit, i get the error
> > that the
> > job has failed and i should contact the server-host if the problem
> > keeps
> > occurring..
> > I know i do something wrong, but what? i'm going nuts with this.
> >
> > Thanks for giving me an answer.
> >
> > "Ronx" wrote:
> >
> >> The FrontPage DRW cannot also send emails. You can, however, write
> >> your own scripts to update the database and send emails.
> >> See http://www.interlacken.com/winnt/tip...ow.aspx?tip=54 for
> >> an
> >> example.
> >> --
> >> Ron Symonds
> >> Microsoft MVP (FrontPage)
> >> Reply only to group - emails will be deleted unread.
> >>
> >> "Mata Stevenson" <(E-Mail Removed)> wrote in message
> >> news:uY$(E-Mail Removed)...
> >> >I was hoping the organization could access and use the .mdb file I
> >> >create in the fpdb directory without using FP. Can they not do
> >> >that?
> >> >
> >> > One other question: is it true that if I have the form input
> >> > results
> >> > go to a database, that they can't be emailed as well, as they can
> >> > be
> >> > if I have the results stored in html?
> >> >
> >> > Thanks, Mata
> >> >
> >> > "Andrew Murray" <(E-Mail Removed)> wrote in message
> >> > news:42901228$0$24863$(E-Mail Removed)...
> >> >> Use the Database results wizard in frontpage.
> >> >>
> >> >> "Mata Stevenson" <(E-Mail Removed)> wrote in message
> >> >> news:uh$(E-Mail Removed)...
> >> >>> Hi helpers,
> >> >>>
> >> >>> I'm creating my first database in FP 2002 to collect data from
> >> >>> a
> >> >>> form and would like to know how the organization I'm doing this
> >> >>> for will retrieve the data. Will they log in to the site every
> >> >>> day, open the fpdb folder, then export the .mdb file to their
> >> >>> drive, and work on it there, setting up the report, etc.? I'm
> >> >>> not
> >> >>> too familiar with Access, and they're not too adept with the
> >> >>> computer in general, so hoping it will be easy.
> >> >>>
> >> >>> Thanks in advance, Mata
> >> >>>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to retrieve records from access database and show in a form willi Microsoft Access Forms 1 27th Mar 2008 03:06 AM
How to retrieve form field value if form is EncType=multipart/form-dataForm? Li Zhang Microsoft ASP .NET 3 20th May 2005 07:50 PM
Retrieve value from database and use in another sub??? =?Utf-8?B?VGltOjouLg==?= Microsoft ASP .NET 1 16th Dec 2004 08:17 PM
Retrieve database id? Mark Kloch Microsoft VB .NET 3 5th Jan 2004 04:19 PM
SOS..Cannot retrieve form database results! Gauthier Microsoft Frontpage 4 8th Dec 2003 04:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:40 AM.