Re: Using Access 2000 w/FP2003 w/XP Home Edition

From: Kathleen Anderson [MVP - FrontPage] (spiderwebwoman_at_mvps.org)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 12:21:04 -0400

Inline. 

-- 
~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
anonymous@discussions.microsoft.com wrote:
> Kathleen,
>
> Thanks for the reply. Yes, I can create them ok under a
> disk-based web site. When I try to use them (disk based)
> via my IE browser to add test data to a database, I get
> various error messages highlited in yellow.
That's because ASP pages/code need to 'served" from a server to work.
>
> I'm an old mainframe programmer
Me, too   :-)
and the thoughts of
> moving code to servers before I'm even sure if they work
> seems backward to me. At least at this stage of the
> development process. I have no formal web or FP training.
> Just a big reference by Paul Colligan. Seems this isn't
> as easy as people seem to think.
>
> From what you said. Does the process work this way.
>
> I create a database with the DRW, using ASP & making it
> disk based.
>
> I then need to "publish" this to a server before I can
> play with them ?
Yes, before you can preview them in your browser.
>
> Meaning I cannot do development work on my stand alone
> PC ?
Sure you can.  You just can't test  :-)
Needs to be published (FTP'd) to a server that
> supports ASP & IIS ?
Yes, and hopefully you'll http publish with FrontPage (not FTP).
>
> Also, are part of my problems trying to develop FP apps
> under XP Home edition ?
You should be able to develop FP apps under XP Home, you just can't test
them.  What you might want to think about is having a subweb created on your
live site where you can publish your ASP pages to, and you can test them in
the subweb before you publish them to your root web. Or, you could upgrade
to XP Pro and install IIS.
>
> Thanks so much for your insight. All of my mainframe
> buddies "play" with FP and Dreamweaver, but never tried
> to develop anything other than a static web sites.
>
> One more question, then I'll stop bugging you.....are
> templates all they are cracked up to be ? I'm looking at
> a companies template (company is AllWebCo) because the
> graphics are alot better than I can do. Plus, they seem
> to have alot of code done that I can tweak. Any thoughts ?
I've never used a template - I can't help you there.
Kathleen
>
>
>> -----Original Message-----
>> Hi Bob:
>> What kind of errors are you getting? Are you getting errors trying
>> to create the DRW pages or are you getting errors when you try to
>> Preview the pages in your browser? I am under the impression that
>> you can use the Database Results Wizard to create ASP pages in a
>> disk-based web but they won't work until you've published them to a
>> Windows server that supports ASP and Access.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft FrontPage MVP
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>>
>> Bob Cultrona <rcultrona@corvette-motorsports.com> wrote:
>>> Folks, I'm new to FP & the web world.
>>>
>>> I've tried using the Database Interface Wizard to build a
>>> database to integrate into a web page and get errors.
>>>
>>> I created Access databases and cannot use them with
>>> FP2003 w/o getting various errors.
>>>
>>> I nosed around MS KBase and found a note that XP Home
>>> edition does not support IIS.
>>>
>>> Therefore, in order to create a "disk based" web site
>>> (during development), do I need to upgrade my PC from
>>> Home Edition to XP Professional Edition in order to use a
>>> database such as Access ?
>>>
>>> Also, if the upgrade is needed, recently I noticed
>>> several upgrades to XP Pro with the note (not full
>>> version). Any idea if these would work ?
>>>
>>> Thanks in  advance.........I'm semi-lost and very
>>> frustrated with this whole process so far !
>>>
>>> Bob
>>
>> .

Relevant Pages

  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: ASP and Access Database queries
    ... http://www.bellfield-barna.com/ is running on an Apache server running ... which doesn't support ASP and Access. ... My Access database is situated in my office. ... I have an Access database where I would like ...
    (microsoft.public.frontpage.programming)
  • Re: Database Connection/ Results not working
    ... After you have created your database connection and renamed your page to .asp, ... You can not test any thing under Windows XP Home ... that requires a MS Web server, ...
    (microsoft.public.frontpage.client)
  • Re: how to solve this?
    ... >Each procedure needs to access the database with parameters (e.g. ... >What i miss is a way to switch between ASP with the database and VB with the ... It is processed on the server. ... and processed on the client. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Is Front page extensions required to run asp pages created by
    ... How to enable the ASP database features without the FrontPage Server ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.extensions.windowsnt)