updating database

Don · Oct 19, 2004

What it is saying is, to get it to give you a better error (One that you
might be able to under stand)

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True

=======================
BTW: Did you try the easy fix download?
Worked here...
I am using FrontPage 2003 and Access 2000
but have not run into the same problem you have.

Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================
| thanks for that, though that entire thread seems to discussing some "error
| message" that one or another of them is seeing.
|
| I am not seeing any error messages. In fact that is one of my worries,
| since it all appears to work, but nothing is actually appended to the db.
I
| have tried the suggestion of copying in FP2K _fpclass files, but that does
| not appear to help. I am not even sure if i had understood the exact
fpclass
| file replacement process. Moreover, depending on how far back I look in
my
| archives of FP03 and FP2k versions of ostensibly the same web, the fpclass
| files are different. In some instances the when i changed to older
fpclass
| files, and saved edits in FP03, it overwrote my newly created "old" files,
| with its own new files.
|
| Quite honestly, this is a bit of "dog's breakfast", and I am appalled that
| MS could release a bit of kit that can cause this enormous mess.
Moreover,
| apparently this problem has been reported since at least June, and here we
| are many months later, and the best I could find on the MS site is to
upgrade
| to ASP.NET ... sure.
|
| Since going back to FP2K is difficult due to its incompatibility with 02
SE,
| I am inclined to follow the suggestions in one part of the thread . move
the
| whole thing to Dreamweaver.
|
|
| "Don" wrote:
|
| > Ted:
| > You may want to read this thread:
| > http://www.frontpagewebmaster.com/m-175524/tm.htm
| > --
| > Hope This Helps
| >
| > Don
| > =====================
| > IEEE Degree
| > MS A+ Certified
| > StarBand Satellite Internet
| > FCC Certified Installer
| > FCC 3rd Class Lic.
| > Playing with FrontPage 2003 ;-)
| > My Playground: www.xmas-i-am.com
| > =====================
| >
| > | > | I'd like to jump in as well. My problem is very similar. Was using
| > | FP2k/Access2k, upgraded to FP03 but still Access2K. Imported/opened
web
| > | originally created with FP2k, it has many forms. E.g. one form writes
to
| > an
| > | MDB (in fpbd) via a process created purely using FP dbWiz etc (no
coding
| > on
| > | our part). The db works for retrieving data, so we know the
connection is
| > | good. Fill form, submit, all looks perfect, the MDB's last modified
date
| > is
| > | consistent with the submit timestamp, but NO data added!
| > |
| > | ISP says their FP2002 SE's etc are all up to date, all permissions
correct
| > | (quadruple checked by ISP admin)
| > |
| > | Somebody said ... rewrite form from scratch in FP03. OK did this,
exactly
| > | same result. Not to mention, rewriting everything from scratch =
| > ruinously
| > | expensive.
| > |
| > | Please Help
| > |
| > |
| > | "LostBoy" wrote:
| > |
| > | > I just wanted to jump in on this conversation...I am having the
exact
| > same
| > | > problem. I am using an Access 2000 database and Frontpage 2002. My
| > | > updating, submitting, and deleting is actually affecting my
database.
| > | >
| > | > The submission form works, but does not affect the db. The delete
| > process
| > | > works, but ends with an error (can't delete from the table), and the
| > udate
| > | > module states there is an UPDATE syntax error. All I did was use
the
| > wizard
| > | > for the three modules. Any ideas?
| > | >
| > | >
| >
| >
| >

Guest · Oct 19, 2004

Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances of
fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of them (and it
declares them twice e.g. 2 dim statements etc). That file is also approx
twice the size of the equivalent file from FP2K (e.g. 4.4k vs. 2.9k). If I
try to use the FP2K version of the inc file, after publish I look at my
fpclass dir, and "lo and behold" my 2.9k inc file has magically become a 4.4k
inc file.

Also, once again, when I press submit, there are no error messages
whatsoever ... everything looks fine (c.f. the thread you were kind of enough
to reference, where they speak specifically of an unintelligible error
message which apparently they are trying to make more intelligible ... or
whatever ...).

Just for â€œfunâ€ I set them to True anyway, and no surprises, the results
occur (i.e. form processing looks perfect, no error messages, confirm page
arrived as expected, mdb modified date/time consistent with submit date, â€¦
but nothing in DB!)

Guest · Oct 19, 2004

OK I got something ... before when I replaced the FP03 fpdbforms.inc it
simply resulted in FP03 overwriting my "fix" with the same FP03 inc file that
I started with. Somehow or another, on further fiddling, I managed to get
the FP2K version of this inc file to "hold", then on publish it now does show
an error message (for the first time) and that error message was just about
clear enough to implement a fix to the db, and now it is working as expected.

Now, it is our understanding that many others in many other locations, and
over many months, have been struggling with this. We upgraded to FP03 4 days
ago, so why is it that MS is still distributing something that has a known
(though obscure) fix (and so could have saved us 8 man days of expenses for
just this one of many FP03 quirks).

Kathleen Anderson [MVP - FrontPage] · Oct 19, 2004

"Microsoft offers several ways for you to send comments or suggestions about
Microsoft products. If you have suggestions for product enhancements that
you would like to see in future versions of Microsoft products, please
contact us by using one of the methods listed later in this article.

Let us know how we can improve our products.

Product Enhancement suggestions can include: "

http://support.microsoft.com/default.aspx?kbid=114491

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Guest · Oct 19, 2004

Thank you for that, and we may consider those avenues. However, I note:

1) Several of the problems we have reported are of a serious code bug
nature, and apparently have been known about for sometime, yet nothing has
been done.

2) Another issue is exemplified by the following: in 1997 one of our staff
had written to MS (via many avenues and to many locations) that the animated
page transitions in Office97/PowerPoint were triggering a pathological
reaction since he suffers from a mild form of epilepsy. Since the animation
cannot be turned off, his life is a misery whenever MSPP is required.

Here it is almost 8 years latter, and guess what .. is there a fix for this?
NO!

This is only one example of many, and as you may imagine such experiences do
thwart motivation, since there appears to be no benefits, but there are costs.

Guest · Oct 19, 2004

Thank you for that, and we may consider those avenues. However, I note:

1) Several of the problems we have reported are of a serious code bug
nature, and apparently have been known about for sometime, yet nothing has
been done or even an announced warning of the "giant chasm".

2) Another issue is exemplified by the following: in 1997 one of our staff
had written to MS (via many avenues and to many locations) that the animated
page transitions in Office97/PowerPoint were triggering a pathological
reaction since he suffers from a mild form of epilepsy. Since the animation
cannot be turned off, his life is a misery whenever MSPP is required.

Here it is almost 8 years latter, and guess what .. is there a fix for this?
NO!

This is only one example of many, and as you may imagine such experiences do
thwart motivation, since there appears to be no benefits, but there are costs.

Don · Oct 19, 2004

To turn off "Page Transitions" In IE go to
Tools>Internet Options> (new window) then to the "Advanced" (tab)
Under Browsing (header) about 11 lines down Uncheck the box that says
"Enable Page Transitions"
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================

| Thank you for that, and we may consider those avenues. However, I note:
|
| 1) Several of the problems we have reported are of a serious code bug
| nature, and apparently have been known about for sometime, yet nothing has
| been done.
|
| 2) Another issue is exemplified by the following: in 1997 one of our
staff
| had written to MS (via many avenues and to many locations) that the
animated
| page transitions in Office97/PowerPoint were triggering a pathological
| reaction since he suffers from a mild form of epilepsy. Since the
animation
| cannot be turned off, his life is a misery whenever MSPP is required.
|
| Here it is almost 8 years latter, and guess what .. is there a fix for
this?
| NO!
|
| This is only one example of many, and as you may imagine such experiences
do
| thwart motivation, since there appears to be no benefits, but there are
costs.
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > "Microsoft offers several ways for you to send comments or suggestions
about
| > Microsoft products. If you have suggestions for product enhancements
that
| > you would like to see in future versions of Microsoft products, please
| > contact us by using one of the methods listed later in this article.
| >
| > Let us know how we can improve our products.
| >
| > Product Enhancement suggestions can include: "
| >
| > http://support.microsoft.com/default.aspx?kbid=114491
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft FrontPage MVP
| > Spider Web Woman Designs
| > http://www.spiderwebwoman.com/resources/
| >
| >
| >
| > > OK I got something ... before when I replaced the FP03 fpdbforms.inc
| > > it
| > > simply resulted in FP03 overwriting my "fix" with the same FP03 inc
| > > file that
| > > I started with. Somehow or another, on further fiddling, I managed
| > > to get
| > > the FP2K version of this inc file to "hold", then on publish it now
| > > does show an error message (for the first time) and that error
| > > message was just about clear enough to implement a fix to the db, and
| > > now it is working as expected.
| > >
| > > Now, it is our understanding that many others in many other
| > > locations, and
| > > over many months, have been struggling with this. We upgraded to
| > > FP03 4 days ago, so why is it that MS is still distributing something
| > > that has a known (though obscure) fix (and so could have saved us 8
| > > man days of expenses for just this one of many FP03 quirks).
| > >
| > >
| > >
| > > "DeltaGamma" wrote:
| > >
| > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances
| > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of
| > >> them (and it declares them twice e.g. 2 dim statements etc). That
| > >> file is also approx twice the size of the equivalent file from FP2K
| > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the inc
| > >> file, after publish I look at my fpclass dir, and "lo and behold" my
| > >> 2.9k inc file has magically become a 4.4k inc file.
| > >>
| > >> Also, once again, when I press submit, there are no error messages
| > >> whatsoever ... everything looks fine (c.f. the thread you were kind
| > >> of enough to reference, where they speak specifically of an
| > >> unintelligible error message which apparently they are trying to
| > >> make more intelligible ... or whatever ...).
| > >>
| > >> Just for â?ofunâ? I set them to True anyway, and no surprises, the
| > >> results occur (i.e. form processing looks perfect, no error
| > >> messages, confirm page arrived as expected, mdb modified date/time
| > >> consistent with submit date, â?¦ but nothing in DB!)
| > >>
| > >>
| > >> "Don" wrote:
| > >>
| > >>> What it is saying is, to get it to give you a better error (One
| > >>> that you might be able to under stand)
| > >>>
| > >>> To see the true error, open the hidden folder /_fpclass/ and edit
| > >>> the fpdbrgn1.inc file
| > >>>
| > >>> At about line 19, change :
| > >>>
| > >>> fp_DEBUG = False
| > >>>
| > >>> to :
| > >>>
| > >>> fp_DEBUG = True
| > >>>
| > >>> =======================
| > >>> BTW: Did you try the easy fix download?
| > >>> Worked here...
| > >>> I am using FrontPage 2003 and Access 2000
| > >>> but have not run into the same problem you have.
| > >>>
| > >>> Hope This Helps
| > >>>
| > >>> Don
| > >>> =====================
| > >>> IEEE Degree
| > >>> MS A+ Certified
| > >>> StarBand Satellite Internet
| > >>> FCC Certified Installer
| > >>> FCC 3rd Class Lic.
| > >>> Playing with FrontPage 2003 ;-)
| > >>> My Playground: www.xmas-i-am.com
| > >>> =====================
| > >>> | > >>>> thanks for that, though that entire thread seems to discussing
| > >>>> some "error message" that one or another of them is seeing.
| > >>>>
| > >>>> I am not seeing any error messages. In fact that is one of my
| > >>>> worries, since it all appears to work, but nothing is actually
| > >>>> appended to the db. I have tried the suggestion of copying in FP2K
| > >>>> _fpclass files, but that does not appear to help. I am not even
| > >>>> sure if i had understood the exact fpclass file replacement
| > >>>> process. Moreover, depending on how far back I look in my
| > >>>> archives of FP03 and FP2k versions of ostensibly the same web, the
| > >>>> fpclass files are different. In some instances the when i changed
| > >>>> to older fpclass files, and saved edits in FP03, it overwrote my
| > >>>> newly created "old" files, with its own new files.
| > >>>>
| > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > >>>> appalled that MS could release a bit of kit that can cause this
| > >>>> enormous mess. Moreover, apparently this problem has been reported
| > >>>> since at least June, and here we are many months later, and the
| > >>>> best I could find on the MS site is to upgrade to ASP.NET ... sure.
| > >>>>
| > >>>> Since going back to FP2K is difficult due to its incompatibility
| > >>>> with 02 SE, I am inclined to follow the suggestions in one part of
| > >>>> the thread . move the whole thing to Dreamweaver.
| > >>>>
| > >>>>
| > >>>> "Don" wrote:
| > >>>>
| > >>>>> Ted:
| > >>>>> You may want to read this thread:
| > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >>>>> --
| > >>>>> Hope This Helps
| > >>>>>
| > >>>>> Don
| > >>>>> =====================
| > >>>>> IEEE Degree
| > >>>>> MS A+ Certified
| > >>>>> StarBand Satellite Internet
| > >>>>> FCC Certified Installer
| > >>>>> FCC 3rd Class Lic.
| > >>>>> Playing with FrontPage 2003 ;-)
| > >>>>> My Playground: www.xmas-i-am.com
| > >>>>> =====================
| > >>>>>
| > >>>>> message | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > >>>>>> Imported/opened web originally created with FP2k, it has many
| > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a process
| > >>>>>> created purely using FP dbWiz etc (no coding on our part). The
| > >>>>>> db works for retrieving data, so we know the connection is good.
| > >>>>>> Fill form, submit, all looks perfect, the MDB's last modified
| > >>>>>> date is consistent with the submit timestamp, but NO data added!
| > >>>>>>
| > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > >>>>>> permissions correct (quadruple checked by ISP admin)
| > >>>>>>
| > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > >>>>>> this, exactly same result. Not to mention, rewriting everything
| > >>>>>> from scratch = ruinously expensive.
| > >>>>>>
| > >>>>>> Please Help
| > >>>>>>
| > >>>>>>
| > >>>>>> "LostBoy" wrote:
| > >>>>>>
| > >>>>>>> I just wanted to jump in on this conversation...I am having the
| > >>>>>>> exact same problem. I am using an Access 2000 database and
| > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > >>>>>>> actually affecting my database.
| > >>>>>>>
| > >>>>>>> The submission form works, but does not affect the db. The
| > >>>>>>> delete process works, but ends with an error (can't delete from
| > >>>>>>> the table), and the udate module states there is an UPDATE
| > >>>>>>> syntax error. All I did was use the wizard for the three
| > >>>>>>> modules. Any ideas?
| >
| >

Don · Oct 19, 2004

Ooops
For got to tell you.. To keep FrontPage 2003 from changing the code. (once
it is back up and running) Change the file attributes to "Read Only"
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================
| Thank you for that, and we may consider those avenues. However, I note:
|
| 1) Several of the problems we have reported are of a serious code bug
| nature, and apparently have been known about for sometime, yet nothing has
| been done.
|
| 2) Another issue is exemplified by the following: in 1997 one of our
staff
| had written to MS (via many avenues and to many locations) that the
animated
| page transitions in Office97/PowerPoint were triggering a pathological
| reaction since he suffers from a mild form of epilepsy. Since the
animation
| cannot be turned off, his life is a misery whenever MSPP is required.
|
| Here it is almost 8 years latter, and guess what .. is there a fix for
this?
| NO!
|
| This is only one example of many, and as you may imagine such experiences
do
| thwart motivation, since there appears to be no benefits, but there are
costs.
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > "Microsoft offers several ways for you to send comments or suggestions
about
| > Microsoft products. If you have suggestions for product enhancements
that
| > you would like to see in future versions of Microsoft products, please
| > contact us by using one of the methods listed later in this article.
| >
| > Let us know how we can improve our products.
| >
| > Product Enhancement suggestions can include: "
| >
| > http://support.microsoft.com/default.aspx?kbid=114491
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft FrontPage MVP
| > Spider Web Woman Designs
| > http://www.spiderwebwoman.com/resources/
| >
| >
| >
| > > OK I got something ... before when I replaced the FP03 fpdbforms.inc
| > > it
| > > simply resulted in FP03 overwriting my "fix" with the same FP03 inc
| > > file that
| > > I started with. Somehow or another, on further fiddling, I managed
| > > to get
| > > the FP2K version of this inc file to "hold", then on publish it now
| > > does show an error message (for the first time) and that error
| > > message was just about clear enough to implement a fix to the db, and
| > > now it is working as expected.
| > >
| > > Now, it is our understanding that many others in many other
| > > locations, and
| > > over many months, have been struggling with this. We upgraded to
| > > FP03 4 days ago, so why is it that MS is still distributing something
| > > that has a known (though obscure) fix (and so could have saved us 8
| > > man days of expenses for just this one of many FP03 quirks).
| > >
| > >
| > >
| > > "DeltaGamma" wrote:
| > >
| > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances
| > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of
| > >> them (and it declares them twice e.g. 2 dim statements etc). That
| > >> file is also approx twice the size of the equivalent file from FP2K
| > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the inc
| > >> file, after publish I look at my fpclass dir, and "lo and behold" my
| > >> 2.9k inc file has magically become a 4.4k inc file.
| > >>
| > >> Also, once again, when I press submit, there are no error messages
| > >> whatsoever ... everything looks fine (c.f. the thread you were kind
| > >> of enough to reference, where they speak specifically of an
| > >> unintelligible error message which apparently they are trying to
| > >> make more intelligible ... or whatever ...).
| > >>
| > >> Just for â?ofunâ? I set them to True anyway, and no surprises, the
| > >> results occur (i.e. form processing looks perfect, no error
| > >> messages, confirm page arrived as expected, mdb modified date/time
| > >> consistent with submit date, â?¦ but nothing in DB!)
| > >>
| > >>
| > >> "Don" wrote:
| > >>
| > >>> What it is saying is, to get it to give you a better error (One
| > >>> that you might be able to under stand)
| > >>>
| > >>> To see the true error, open the hidden folder /_fpclass/ and edit
| > >>> the fpdbrgn1.inc file
| > >>>
| > >>> At about line 19, change :
| > >>>
| > >>> fp_DEBUG = False
| > >>>
| > >>> to :
| > >>>
| > >>> fp_DEBUG = True
| > >>>
| > >>> =======================
| > >>> BTW: Did you try the easy fix download?
| > >>> Worked here...
| > >>> I am using FrontPage 2003 and Access 2000
| > >>> but have not run into the same problem you have.
| > >>>
| > >>> Hope This Helps
| > >>>
| > >>> Don
| > >>> =====================
| > >>> IEEE Degree
| > >>> MS A+ Certified
| > >>> StarBand Satellite Internet
| > >>> FCC Certified Installer
| > >>> FCC 3rd Class Lic.
| > >>> Playing with FrontPage 2003 ;-)
| > >>> My Playground: www.xmas-i-am.com
| > >>> =====================
| > >>> | > >>>> thanks for that, though that entire thread seems to discussing
| > >>>> some "error message" that one or another of them is seeing.
| > >>>>
| > >>>> I am not seeing any error messages. In fact that is one of my
| > >>>> worries, since it all appears to work, but nothing is actually
| > >>>> appended to the db. I have tried the suggestion of copying in FP2K
| > >>>> _fpclass files, but that does not appear to help. I am not even
| > >>>> sure if i had understood the exact fpclass file replacement
| > >>>> process. Moreover, depending on how far back I look in my
| > >>>> archives of FP03 and FP2k versions of ostensibly the same web, the
| > >>>> fpclass files are different. In some instances the when i changed
| > >>>> to older fpclass files, and saved edits in FP03, it overwrote my
| > >>>> newly created "old" files, with its own new files.
| > >>>>
| > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > >>>> appalled that MS could release a bit of kit that can cause this
| > >>>> enormous mess. Moreover, apparently this problem has been reported
| > >>>> since at least June, and here we are many months later, and the
| > >>>> best I could find on the MS site is to upgrade to ASP.NET ... sure.
| > >>>>
| > >>>> Since going back to FP2K is difficult due to its incompatibility
| > >>>> with 02 SE, I am inclined to follow the suggestions in one part of
| > >>>> the thread . move the whole thing to Dreamweaver.
| > >>>>
| > >>>>
| > >>>> "Don" wrote:
| > >>>>
| > >>>>> Ted:
| > >>>>> You may want to read this thread:
| > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >>>>> --
| > >>>>> Hope This Helps
| > >>>>>
| > >>>>> Don
| > >>>>> =====================
| > >>>>> IEEE Degree
| > >>>>> MS A+ Certified
| > >>>>> StarBand Satellite Internet
| > >>>>> FCC Certified Installer
| > >>>>> FCC 3rd Class Lic.
| > >>>>> Playing with FrontPage 2003 ;-)
| > >>>>> My Playground: www.xmas-i-am.com
| > >>>>> =====================
| > >>>>>
| > >>>>> message | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > >>>>>> Imported/opened web originally created with FP2k, it has many
| > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a process
| > >>>>>> created purely using FP dbWiz etc (no coding on our part). The
| > >>>>>> db works for retrieving data, so we know the connection is good.
| > >>>>>> Fill form, submit, all looks perfect, the MDB's last modified
| > >>>>>> date is consistent with the submit timestamp, but NO data added!
| > >>>>>>
| > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > >>>>>> permissions correct (quadruple checked by ISP admin)
| > >>>>>>
| > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > >>>>>> this, exactly same result. Not to mention, rewriting everything
| > >>>>>> from scratch = ruinously expensive.
| > >>>>>>
| > >>>>>> Please Help
| > >>>>>>
| > >>>>>>
| > >>>>>> "LostBoy" wrote:
| > >>>>>>
| > >>>>>>> I just wanted to jump in on this conversation...I am having the
| > >>>>>>> exact same problem. I am using an Access 2000 database and
| > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > >>>>>>> actually affecting my database.
| > >>>>>>>
| > >>>>>>> The submission form works, but does not affect the db. The
| > >>>>>>> delete process works, but ends with an error (can't delete from
| > >>>>>>> the table), and the udate module states there is an UPDATE
| > >>>>>>> syntax error. All I did was use the wizard for the three
| > >>>>>>> modules. Any ideas?
| >
| >

Guest · Oct 19, 2004

Thanks, we know that and have had if off for years. Importantly, it does not
appear to effect MSPP, and perhaps you would like to try that yourself and
let me if you your MSPP the transitioning is off.

Don said:
To turn off "Page Transitions" In IE go to
Tools>Internet Options> (new window) then to the "Advanced" (tab)
Under Browsing (header) about 11 lines down Uncheck the box that says
"Enable Page Transitions"
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================

| Thank you for that, and we may consider those avenues. However, I note:
|
| 1) Several of the problems we have reported are of a serious code bug
| nature, and apparently have been known about for sometime, yet nothing has
| been done.
|
| 2) Another issue is exemplified by the following: in 1997 one of our
staff
| had written to MS (via many avenues and to many locations) that the
animated
| page transitions in Office97/PowerPoint were triggering a pathological
| reaction since he suffers from a mild form of epilepsy. Since the
animation
| cannot be turned off, his life is a misery whenever MSPP is required.
|
| Here it is almost 8 years latter, and guess what .. is there a fix for
this?
| NO!
|
| This is only one example of many, and as you may imagine such experiences
do
| thwart motivation, since there appears to be no benefits, but there are
costs.
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > "Microsoft offers several ways for you to send comments or suggestions
about
| > Microsoft products. If you have suggestions for product enhancements
that
| > you would like to see in future versions of Microsoft products, please
| > contact us by using one of the methods listed later in this article.
| >
| > Let us know how we can improve our products.
| >
| > Product Enhancement suggestions can include: "
| >
| > http://support.microsoft.com/default.aspx?kbid=114491
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft FrontPage MVP
| > Spider Web Woman Designs
| > http://www.spiderwebwoman.com/resources/
| >
| >
| >
| > > OK I got something ... before when I replaced the FP03 fpdbforms.inc
| > > it
| > > simply resulted in FP03 overwriting my "fix" with the same FP03 inc
| > > file that
| > > I started with. Somehow or another, on further fiddling, I managed
| > > to get
| > > the FP2K version of this inc file to "hold", then on publish it now
| > > does show an error message (for the first time) and that error
| > > message was just about clear enough to implement a fix to the db, and
| > > now it is working as expected.
| > >
| > > Now, it is our understanding that many others in many other
| > > locations, and
| > > over many months, have been struggling with this. We upgraded to
| > > FP03 4 days ago, so why is it that MS is still distributing something
| > > that has a known (though obscure) fix (and so could have saved us 8
| > > man days of expenses for just this one of many FP03 quirks).
| > >
| > >
| > >
| > > "DeltaGamma" wrote:
| > >
| > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances
| > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of
| > >> them (and it declares them twice e.g. 2 dim statements etc). That
| > >> file is also approx twice the size of the equivalent file from FP2K
| > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the inc
| > >> file, after publish I look at my fpclass dir, and "lo and behold" my
| > >> 2.9k inc file has magically become a 4.4k inc file.
| > >>
| > >> Also, once again, when I press submit, there are no error messages
| > >> whatsoever ... everything looks fine (c.f. the thread you were kind
| > >> of enough to reference, where they speak specifically of an
| > >> unintelligible error message which apparently they are trying to
| > >> make more intelligible ... or whatever ...).
| > >>
| > >> Just for Ã¢?ofunÃ¢?Â I set them to True anyway, and no surprises, the
| > >> results occur (i.e. form processing looks perfect, no error
| > >> messages, confirm page arrived as expected, mdb modified date/time
| > >> consistent with submit date, Ã¢?Â¦ but nothing in DB!)
| > >>
| > >>
| > >> "Don" wrote:
| > >>
| > >>> What it is saying is, to get it to give you a better error (One
| > >>> that you might be able to under stand)
| > >>>
| > >>> To see the true error, open the hidden folder /_fpclass/ and edit
| > >>> the fpdbrgn1.inc file
| > >>>
| > >>> At about line 19, change :
| > >>>
| > >>> fp_DEBUG = False
| > >>>
| > >>> to :
| > >>>
| > >>> fp_DEBUG = True
| > >>>
| > >>> =======================
| > >>> BTW: Did you try the easy fix download?
| > >>> Worked here...
| > >>> I am using FrontPage 2003 and Access 2000
| > >>> but have not run into the same problem you have.
| > >>>
| > >>> Hope This Helps
| > >>>
| > >>> Don
| > >>> =====================
| > >>> IEEE Degree
| > >>> MS A+ Certified
| > >>> StarBand Satellite Internet
| > >>> FCC Certified Installer
| > >>> FCC 3rd Class Lic.
| > >>> Playing with FrontPage 2003 ;-)
| > >>> My Playground: www.xmas-i-am.com
| > >>> =====================
| > >>> | > >>>> thanks for that, though that entire thread seems to discussing
| > >>>> some "error message" that one or another of them is seeing.
| > >>>>
| > >>>> I am not seeing any error messages. In fact that is one of my
| > >>>> worries, since it all appears to work, but nothing is actually
| > >>>> appended to the db. I have tried the suggestion of copying in FP2K
| > >>>> _fpclass files, but that does not appear to help. I am not even
| > >>>> sure if i had understood the exact fpclass file replacement
| > >>>> process. Moreover, depending on how far back I look in my
| > >>>> archives of FP03 and FP2k versions of ostensibly the same web, the
| > >>>> fpclass files are different. In some instances the when i changed
| > >>>> to older fpclass files, and saved edits in FP03, it overwrote my
| > >>>> newly created "old" files, with its own new files.
| > >>>>
| > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > >>>> appalled that MS could release a bit of kit that can cause this
| > >>>> enormous mess. Moreover, apparently this problem has been reported
| > >>>> since at least June, and here we are many months later, and the
| > >>>> best I could find on the MS site is to upgrade to ASP.NET ... sure.
| > >>>>
| > >>>> Since going back to FP2K is difficult due to its incompatibility
| > >>>> with 02 SE, I am inclined to follow the suggestions in one part of
| > >>>> the thread . move the whole thing to Dreamweaver.
| > >>>>
| > >>>>
| > >>>> "Don" wrote:
| > >>>>
| > >>>>> Ted:
| > >>>>> You may want to read this thread:
| > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >>>>> --
| > >>>>> Hope This Helps
| > >>>>>
| > >>>>> Don
| > >>>>> =====================
| > >>>>> IEEE Degree
| > >>>>> MS A+ Certified
| > >>>>> StarBand Satellite Internet
| > >>>>> FCC Certified Installer
| > >>>>> FCC 3rd Class Lic.
| > >>>>> Playing with FrontPage 2003 ;-)
| > >>>>> My Playground: www.xmas-i-am.com
| > >>>>> =====================
| > >>>>>
| > >>>>> message | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > >>>>>> Imported/opened web originally created with FP2k, it has many
| > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a process
| > >>>>>> created purely using FP dbWiz etc (no coding on our part). The
| > >>>>>> db works for retrieving data, so we know the connection is good.
| > >>>>>> Fill form, submit, all looks perfect, the MDB's last modified
| > >>>>>> date is consistent with the submit timestamp, but NO data added!
| > >>>>>>
| > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > >>>>>> permissions correct (quadruple checked by ISP admin)
| > >>>>>>
| > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > >>>>>> this, exactly same result. Not to mention, rewriting everything
| > >>>>>> from scratch = ruinously expensive.
| > >>>>>>
| > >>>>>> Please Help
| > >>>>>>
| > >>>>>>
| > >>>>>> "LostBoy" wrote:
| > >>>>>>
| > >>>>>>> I just wanted to jump in on this conversation...I am having the
| > >>>>>>> exact same problem. I am using an Access 2000 database and
| > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > >>>>>>> actually affecting my database.
| > >>>>>>>
| > >>>>>>> The submission form works, but does not affect the db. The
| > >>>>>>> delete process works, but ends with an error (can't delete from
| > >>>>>>> the table), and the udate module states there is an UPDATE
| > >>>>>>> syntax error. All I did was use the wizard for the three
| > >>>>>>> modules. Any ideas?
| >
| >

Thomas A. Rowe · Oct 19, 2004

Read-Only doesn't apply to html pages when open in FP, unless changed in FP2003.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Don said:
Ooops
For got to tell you.. To keep FrontPage 2003 from changing the code. (once
it is back up and running) Change the file attributes to "Read Only"
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================
| Thank you for that, and we may consider those avenues. However, I note:
|
| 1) Several of the problems we have reported are of a serious code bug
| nature, and apparently have been known about for sometime, yet nothing has
| been done.
|
| 2) Another issue is exemplified by the following: in 1997 one of our
staff
| had written to MS (via many avenues and to many locations) that the
animated
| page transitions in Office97/PowerPoint were triggering a pathological
| reaction since he suffers from a mild form of epilepsy. Since the
animation
| cannot be turned off, his life is a misery whenever MSPP is required.
|
| Here it is almost 8 years latter, and guess what .. is there a fix for
this?
| NO!
|
| This is only one example of many, and as you may imagine such experiences
do
| thwart motivation, since there appears to be no benefits, but there are
costs.
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > "Microsoft offers several ways for you to send comments or suggestions
about
| > Microsoft products. If you have suggestions for product enhancements
that
| > you would like to see in future versions of Microsoft products, please
| > contact us by using one of the methods listed later in this article.
| >
| > Let us know how we can improve our products.
| >
| > Product Enhancement suggestions can include: "
| >
| > http://support.microsoft.com/default.aspx?kbid=114491
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft FrontPage MVP
| > Spider Web Woman Designs
| > http://www.spiderwebwoman.com/resources/
| >
| >
| >
| > > OK I got something ... before when I replaced the FP03 fpdbforms.inc
| > > it
| > > simply resulted in FP03 overwriting my "fix" with the same FP03 inc
| > > file that
| > > I started with. Somehow or another, on further fiddling, I managed
| > > to get
| > > the FP2K version of this inc file to "hold", then on publish it now
| > > does show an error message (for the first time) and that error
| > > message was just about clear enough to implement a fix to the db, and
| > > now it is working as expected.
| > >
| > > Now, it is our understanding that many others in many other
| > > locations, and
| > > over many months, have been struggling with this. We upgraded to
| > > FP03 4 days ago, so why is it that MS is still distributing something
| > > that has a known (though obscure) fix (and so could have saved us 8
| > > man days of expenses for just this one of many FP03 quirks).
| > >
| > >
| > >
| > > "DeltaGamma" wrote:
| > >
| > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances
| > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of
| > >> them (and it declares them twice e.g. 2 dim statements etc). That
| > >> file is also approx twice the size of the equivalent file from FP2K
| > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the inc
| > >> file, after publish I look at my fpclass dir, and "lo and behold" my
| > >> 2.9k inc file has magically become a 4.4k inc file.
| > >>
| > >> Also, once again, when I press submit, there are no error messages
| > >> whatsoever ... everything looks fine (c.f. the thread you were kind
| > >> of enough to reference, where they speak specifically of an
| > >> unintelligible error message which apparently they are trying to
| > >> make more intelligible ... or whatever ...).
| > >>
| > >> Just for â?ofunâ? I set them to True anyway, and no surprises, the
| > >> results occur (i.e. form processing looks perfect, no error
| > >> messages, confirm page arrived as expected, mdb modified date/time
| > >> consistent with submit date, â?¦ but nothing in DB!)
| > >>
| > >>
| > >> "Don" wrote:
| > >>
| > >>> What it is saying is, to get it to give you a better error (One
| > >>> that you might be able to under stand)
| > >>>
| > >>> To see the true error, open the hidden folder /_fpclass/ and edit
| > >>> the fpdbrgn1.inc file
| > >>>
| > >>> At about line 19, change :
| > >>>
| > >>> fp_DEBUG = False
| > >>>
| > >>> to :
| > >>>
| > >>> fp_DEBUG = True
| > >>>
| > >>> =======================
| > >>> BTW: Did you try the easy fix download?
| > >>> Worked here...
| > >>> I am using FrontPage 2003 and Access 2000
| > >>> but have not run into the same problem you have.
| > >>>
| > >>> Hope This Helps
| > >>>
| > >>> Don
| > >>> =====================
| > >>> IEEE Degree
| > >>> MS A+ Certified
| > >>> StarBand Satellite Internet
| > >>> FCC Certified Installer
| > >>> FCC 3rd Class Lic.
| > >>> Playing with FrontPage 2003 ;-)
| > >>> My Playground: www.xmas-i-am.com
| > >>> =====================
| > >>> | > >>>> thanks for that, though that entire thread seems to discussing
| > >>>> some "error message" that one or another of them is seeing.
| > >>>>
| > >>>> I am not seeing any error messages. In fact that is one of my
| > >>>> worries, since it all appears to work, but nothing is actually
| > >>>> appended to the db. I have tried the suggestion of copying in FP2K
| > >>>> _fpclass files, but that does not appear to help. I am not even
| > >>>> sure if i had understood the exact fpclass file replacement
| > >>>> process. Moreover, depending on how far back I look in my
| > >>>> archives of FP03 and FP2k versions of ostensibly the same web, the
| > >>>> fpclass files are different. In some instances the when i changed
| > >>>> to older fpclass files, and saved edits in FP03, it overwrote my
| > >>>> newly created "old" files, with its own new files.
| > >>>>
| > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > >>>> appalled that MS could release a bit of kit that can cause this
| > >>>> enormous mess. Moreover, apparently this problem has been reported
| > >>>> since at least June, and here we are many months later, and the
| > >>>> best I could find on the MS site is to upgrade to ASP.NET ... sure.
| > >>>>
| > >>>> Since going back to FP2K is difficult due to its incompatibility
| > >>>> with 02 SE, I am inclined to follow the suggestions in one part of
| > >>>> the thread . move the whole thing to Dreamweaver.
| > >>>>
| > >>>>
| > >>>> "Don" wrote:
| > >>>>
| > >>>>> Ted:
| > >>>>> You may want to read this thread:
| > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >>>>> --
| > >>>>> Hope This Helps
| > >>>>>
| > >>>>> Don
| > >>>>> =====================
| > >>>>> IEEE Degree
| > >>>>> MS A+ Certified
| > >>>>> StarBand Satellite Internet
| > >>>>> FCC Certified Installer
| > >>>>> FCC 3rd Class Lic.
| > >>>>> Playing with FrontPage 2003 ;-)
| > >>>>> My Playground: www.xmas-i-am.com
| > >>>>> =====================
| > >>>>>
| > >>>>> message | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > >>>>>> Imported/opened web originally created with FP2k, it has many
| > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a process
| > >>>>>> created purely using FP dbWiz etc (no coding on our part). The
| > >>>>>> db works for retrieving data, so we know the connection is good.
| > >>>>>> Fill form, submit, all looks perfect, the MDB's last modified
| > >>>>>> date is consistent with the submit timestamp, but NO data added!
| > >>>>>>
| > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > >>>>>> permissions correct (quadruple checked by ISP admin)
| > >>>>>>
| > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > >>>>>> this, exactly same result. Not to mention, rewriting everything
| > >>>>>> from scratch = ruinously expensive.
| > >>>>>>
| > >>>>>> Please Help
| > >>>>>>
| > >>>>>>
| > >>>>>> "LostBoy" wrote:
| > >>>>>>
| > >>>>>>> I just wanted to jump in on this conversation...I am having the
| > >>>>>>> exact same problem. I am using an Access 2000 database and
| > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > >>>>>>> actually affecting my database.
| > >>>>>>>
| > >>>>>>> The submission form works, but does not affect the db. The
| > >>>>>>> delete process works, but ends with an error (can't delete from
| > >>>>>>> the table), and the udate module states there is an UPDATE
| > >>>>>>> syntax error. All I did was use the wizard for the three
| > >>>>>>> modules. Any ideas?
| >
| >

Guest · Oct 19, 2004

Thanks for that, though I have noticed the fpdbforms.inc file is "dynamic"
and appears to change (I presumed as a result of forms/dbs being added/edited
etc). If I make it read-only, wont that prevent its ability to update?

Don said:
Ooops
For got to tell you.. To keep FrontPage 2003 from changing the code. (once
it is back up and running) Change the file attributes to "Read Only"
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================
| Thank you for that, and we may consider those avenues. However, I note:
|
| 1) Several of the problems we have reported are of a serious code bug
| nature, and apparently have been known about for sometime, yet nothing has
| been done.
|
| 2) Another issue is exemplified by the following: in 1997 one of our
staff
| had written to MS (via many avenues and to many locations) that the
animated
| page transitions in Office97/PowerPoint were triggering a pathological
| reaction since he suffers from a mild form of epilepsy. Since the
animation
| cannot be turned off, his life is a misery whenever MSPP is required.
|
| Here it is almost 8 years latter, and guess what .. is there a fix for
this?
| NO!
|
| This is only one example of many, and as you may imagine such experiences
do
| thwart motivation, since there appears to be no benefits, but there are
costs.
|
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > "Microsoft offers several ways for you to send comments or suggestions
about
| > Microsoft products. If you have suggestions for product enhancements
that
| > you would like to see in future versions of Microsoft products, please
| > contact us by using one of the methods listed later in this article.
| >
| > Let us know how we can improve our products.
| >
| > Product Enhancement suggestions can include: "
| >
| > http://support.microsoft.com/default.aspx?kbid=114491
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft FrontPage MVP
| > Spider Web Woman Designs
| > http://www.spiderwebwoman.com/resources/
| >
| >
| >
| > > OK I got something ... before when I replaced the FP03 fpdbforms.inc
| > > it
| > > simply resulted in FP03 overwriting my "fix" with the same FP03 inc
| > > file that
| > > I started with. Somehow or another, on further fiddling, I managed
| > > to get
| > > the FP2K version of this inc file to "hold", then on publish it now
| > > does show an error message (for the first time) and that error
| > > message was just about clear enough to implement a fix to the db, and
| > > now it is working as expected.
| > >
| > > Now, it is our understanding that many others in many other
| > > locations, and
| > > over many months, have been struggling with this. We upgraded to
| > > FP03 4 days ago, so why is it that MS is still distributing something
| > > that has a known (though obscure) fix (and so could have saved us 8
| > > man days of expenses for just this one of many FP03 quirks).
| > >
| > >
| > >
| > > "DeltaGamma" wrote:
| > >
| > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an instances
| > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two) of
| > >> them (and it declares them twice e.g. 2 dim statements etc). That
| > >> file is also approx twice the size of the equivalent file from FP2K
| > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the inc
| > >> file, after publish I look at my fpclass dir, and "lo and behold" my
| > >> 2.9k inc file has magically become a 4.4k inc file.
| > >>
| > >> Also, once again, when I press submit, there are no error messages
| > >> whatsoever ... everything looks fine (c.f. the thread you were kind
| > >> of enough to reference, where they speak specifically of an
| > >> unintelligible error message which apparently they are trying to
| > >> make more intelligible ... or whatever ...).
| > >>
| > >> Just for Ã¢?ofunÃ¢?Â I set them to True anyway, and no surprises, the
| > >> results occur (i.e. form processing looks perfect, no error
| > >> messages, confirm page arrived as expected, mdb modified date/time
| > >> consistent with submit date, Ã¢?Â¦ but nothing in DB!)
| > >>
| > >>
| > >> "Don" wrote:
| > >>
| > >>> What it is saying is, to get it to give you a better error (One
| > >>> that you might be able to under stand)
| > >>>
| > >>> To see the true error, open the hidden folder /_fpclass/ and edit
| > >>> the fpdbrgn1.inc file
| > >>>
| > >>> At about line 19, change :
| > >>>
| > >>> fp_DEBUG = False
| > >>>
| > >>> to :
| > >>>
| > >>> fp_DEBUG = True
| > >>>
| > >>> =======================
| > >>> BTW: Did you try the easy fix download?
| > >>> Worked here...
| > >>> I am using FrontPage 2003 and Access 2000
| > >>> but have not run into the same problem you have.
| > >>>
| > >>> Hope This Helps
| > >>>
| > >>> Don
| > >>> =====================
| > >>> IEEE Degree
| > >>> MS A+ Certified
| > >>> StarBand Satellite Internet
| > >>> FCC Certified Installer
| > >>> FCC 3rd Class Lic.
| > >>> Playing with FrontPage 2003 ;-)
| > >>> My Playground: www.xmas-i-am.com
| > >>> =====================
| > >>> | > >>>> thanks for that, though that entire thread seems to discussing
| > >>>> some "error message" that one or another of them is seeing.
| > >>>>
| > >>>> I am not seeing any error messages. In fact that is one of my
| > >>>> worries, since it all appears to work, but nothing is actually
| > >>>> appended to the db. I have tried the suggestion of copying in FP2K
| > >>>> _fpclass files, but that does not appear to help. I am not even
| > >>>> sure if i had understood the exact fpclass file replacement
| > >>>> process. Moreover, depending on how far back I look in my
| > >>>> archives of FP03 and FP2k versions of ostensibly the same web, the
| > >>>> fpclass files are different. In some instances the when i changed
| > >>>> to older fpclass files, and saved edits in FP03, it overwrote my
| > >>>> newly created "old" files, with its own new files.
| > >>>>
| > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > >>>> appalled that MS could release a bit of kit that can cause this
| > >>>> enormous mess. Moreover, apparently this problem has been reported
| > >>>> since at least June, and here we are many months later, and the
| > >>>> best I could find on the MS site is to upgrade to ASP.NET ... sure.
| > >>>>
| > >>>> Since going back to FP2K is difficult due to its incompatibility
| > >>>> with 02 SE, I am inclined to follow the suggestions in one part of
| > >>>> the thread . move the whole thing to Dreamweaver.
| > >>>>
| > >>>>
| > >>>> "Don" wrote:
| > >>>>
| > >>>>> Ted:
| > >>>>> You may want to read this thread:
| > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > >>>>> --
| > >>>>> Hope This Helps
| > >>>>>
| > >>>>> Don
| > >>>>> =====================
| > >>>>> IEEE Degree
| > >>>>> MS A+ Certified
| > >>>>> StarBand Satellite Internet
| > >>>>> FCC Certified Installer
| > >>>>> FCC 3rd Class Lic.
| > >>>>> Playing with FrontPage 2003 ;-)
| > >>>>> My Playground: www.xmas-i-am.com
| > >>>>> =====================
| > >>>>>
| > >>>>> message | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > >>>>>> Imported/opened web originally created with FP2k, it has many
| > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a process
| > >>>>>> created purely using FP dbWiz etc (no coding on our part). The
| > >>>>>> db works for retrieving data, so we know the connection is good.
| > >>>>>> Fill form, submit, all looks perfect, the MDB's last modified
| > >>>>>> date is consistent with the submit timestamp, but NO data added!
| > >>>>>>
| > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > >>>>>> permissions correct (quadruple checked by ISP admin)
| > >>>>>>
| > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > >>>>>> this, exactly same result. Not to mention, rewriting everything
| > >>>>>> from scratch = ruinously expensive.
| > >>>>>>
| > >>>>>> Please Help
| > >>>>>>
| > >>>>>>
| > >>>>>> "LostBoy" wrote:
| > >>>>>>
| > >>>>>>> I just wanted to jump in on this conversation...I am having the
| > >>>>>>> exact same problem. I am using an Access 2000 database and
| > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > >>>>>>> actually affecting my database.
| > >>>>>>>
| > >>>>>>> The submission form works, but does not affect the db. The
| > >>>>>>> delete process works, but ends with an error (can't delete from
| > >>>>>>> the table), and the udate module states there is an UPDATE
| > >>>>>>> syntax error. All I did was use the wizard for the three
| > >>>>>>> modules. Any ideas?
| >
| >

Don · Oct 19, 2004

Not an HTML page... fpdblib.inc 8)

Don
===============
| Read-Only doesn't apply to html pages when open in FP, unless changed in
FP2003.
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| WEBMASTER Resources(tm)
|
| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| ==============================================
| To assist you in getting the best answers for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
|
| > Ooops
| > For got to tell you.. To keep FrontPage 2003 from changing the code.
(once
| > it is back up and running) Change the file attributes to "Read Only"
| > --
| > Hope This Helps
| >
| > Don
| > =====================
| > IEEE Degree
| > MS A+ Certified
| > StarBand Satellite Internet
| > FCC Certified Installer
| > FCC 3rd Class Lic.
| > Playing with FrontPage 2003 ;-)
| > My Playground: www.xmas-i-am.com
| > =====================
| > | > | Thank you for that, and we may consider those avenues. However, I
note:
| > |
| > | 1) Several of the problems we have reported are of a serious code bug
| > | nature, and apparently have been known about for sometime, yet nothing
has
| > | been done.
| > |
| > | 2) Another issue is exemplified by the following: in 1997 one of our
| > staff
| > | had written to MS (via many avenues and to many locations) that the
| > animated
| > | page transitions in Office97/PowerPoint were triggering a pathological
| > | reaction since he suffers from a mild form of epilepsy. Since the
| > animation
| > | cannot be turned off, his life is a misery whenever MSPP is required.
| > |
| > | Here it is almost 8 years latter, and guess what .. is there a fix for
| > this?
| > | NO!
| > |
| > | This is only one example of many, and as you may imagine such
experiences
| > do
| > | thwart motivation, since there appears to be no benefits, but there
are
| > costs.
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > "Microsoft offers several ways for you to send comments or
suggestions
| > about
| > | > Microsoft products. If you have suggestions for product enhancements
| > that
| > | > you would like to see in future versions of Microsoft products,
please
| > | > contact us by using one of the methods listed later in this article.
| > | >
| > | > Let us know how we can improve our products.
| > | >
| > | > Product Enhancement suggestions can include: "
| > | >
| > | > http://support.microsoft.com/default.aspx?kbid=114491
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft FrontPage MVP
| > | > Spider Web Woman Designs
| > | > http://www.spiderwebwoman.com/resources/
| > | >
| > | >
| > | >
| > | > > OK I got something ... before when I replaced the FP03
fpdbforms.inc
| > | > > it
| > | > > simply resulted in FP03 overwriting my "fix" with the same FP03
inc
| > | > > file that
| > | > > I started with. Somehow or another, on further fiddling, I
managed
| > | > > to get
| > | > > the FP2K version of this inc file to "hold", then on publish it
now
| > | > > does show an error message (for the first time) and that error
| > | > > message was just about clear enough to implement a fix to the db,
and
| > | > > now it is working as expected.
| > | > >
| > | > > Now, it is our understanding that many others in many other
| > | > > locations, and
| > | > > over many months, have been struggling with this. We upgraded to
| > | > > FP03 4 days ago, so why is it that MS is still distributing
something
| > | > > that has a known (though obscure) fix (and so could have saved us
8
| > | > > man days of expenses for just this one of many FP03 quirks).
| > | > >
| > | > >
| > | > >
| > | > > "DeltaGamma" wrote:
| > | > >
| > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
instances
| > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two)
of
| > | > >> them (and it declares them twice e.g. 2 dim statements etc).
That
| > | > >> file is also approx twice the size of the equivalent file from
FP2K
| > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the
inc
| > | > >> file, after publish I look at my fpclass dir, and "lo and behold"
my
| > | > >> 2.9k inc file has magically become a 4.4k inc file.
| > | > >>
| > | > >> Also, once again, when I press submit, there are no error
messages
| > | > >> whatsoever ... everything looks fine (c.f. the thread you were
kind
| > | > >> of enough to reference, where they speak specifically of an
| > | > >> unintelligible error message which apparently they are trying to
| > | > >> make more intelligible ... or whatever ...).
| > | > >>
| > | > >> Just for â?ofunâ? I set them to True anyway, and no surprises,
the
| > | > >> results occur (i.e. form processing looks perfect, no error
| > | > >> messages, confirm page arrived as expected, mdb modified
date/time
| > | > >> consistent with submit date, â?¦ but nothing in DB!)
| > | > >>
| > | > >>
| > | > >> "Don" wrote:
| > | > >>
| > | > >>> What it is saying is, to get it to give you a better error (One
| > | > >>> that you might be able to under stand)
| > | > >>>
| > | > >>> To see the true error, open the hidden folder /_fpclass/ and
edit
| > | > >>> the fpdbrgn1.inc file
| > | > >>>
| > | > >>> At about line 19, change :
| > | > >>>
| > | > >>> fp_DEBUG = False
| > | > >>>
| > | > >>> to :
| > | > >>>
| > | > >>> fp_DEBUG = True
| > | > >>>
| > | > >>> =======================
| > | > >>> BTW: Did you try the easy fix download?
| > | > >>> Worked here...
| > | > >>> I am using FrontPage 2003 and Access 2000
| > | > >>> but have not run into the same problem you have.
| > | > >>>
| > | > >>> Hope This Helps
| > | > >>>
| > | > >>> Don
| > | > >>> =====================
| > | > >>> IEEE Degree
| > | > >>> MS A+ Certified
| > | > >>> StarBand Satellite Internet
| > | > >>> FCC Certified Installer
| > | > >>> FCC 3rd Class Lic.
| > | > >>> Playing with FrontPage 2003 ;-)
| > | > >>> My Playground: www.xmas-i-am.com
| > | > >>> =====================
message
| > | > >>> | > | > >>>> thanks for that, though that entire thread seems to discussing
| > | > >>>> some "error message" that one or another of them is seeing.
| > | > >>>>
| > | > >>>> I am not seeing any error messages. In fact that is one of my
| > | > >>>> worries, since it all appears to work, but nothing is actually
| > | > >>>> appended to the db. I have tried the suggestion of copying in
FP2K
| > | > >>>> _fpclass files, but that does not appear to help. I am not
even
| > | > >>>> sure if i had understood the exact fpclass file replacement
| > | > >>>> process. Moreover, depending on how far back I look in my
| > | > >>>> archives of FP03 and FP2k versions of ostensibly the same web,
the
| > | > >>>> fpclass files are different. In some instances the when i
changed
| > | > >>>> to older fpclass files, and saved edits in FP03, it overwrote
my
| > | > >>>> newly created "old" files, with its own new files.
| > | > >>>>
| > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > | > >>>> appalled that MS could release a bit of kit that can cause this
| > | > >>>> enormous mess. Moreover, apparently this problem has been
reported
| > | > >>>> since at least June, and here we are many months later, and the
| > | > >>>> best I could find on the MS site is to upgrade to ASP.NET ...
sure.
| > | > >>>>
| > | > >>>> Since going back to FP2K is difficult due to its
incompatibility
| > | > >>>> with 02 SE, I am inclined to follow the suggestions in one part
of
| > | > >>>> the thread . move the whole thing to Dreamweaver.
| > | > >>>>
| > | > >>>>
| > | > >>>> "Don" wrote:
| > | > >>>>
| > | > >>>>> Ted:
| > | > >>>>> You may want to read this thread:
| > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > | > >>>>> --
| > | > >>>>> Hope This Helps
| > | > >>>>>
| > | > >>>>> Don
| > | > >>>>> =====================
| > | > >>>>> IEEE Degree
| > | > >>>>> MS A+ Certified
| > | > >>>>> StarBand Satellite Internet
| > | > >>>>> FCC Certified Installer
| > | > >>>>> FCC 3rd Class Lic.
| > | > >>>>> Playing with FrontPage 2003 ;-)
| > | > >>>>> My Playground: www.xmas-i-am.com
| > | > >>>>> =====================
| > | > >>>>>
| > | > >>>>> message
| > | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > | > >>>>>> Imported/opened web originally created with FP2k, it has many
| > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
process
| > | > >>>>>> created purely using FP dbWiz etc (no coding on our part).
The
| > | > >>>>>> db works for retrieving data, so we know the connection is
good.
| > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
modified
| > | > >>>>>> date is consistent with the submit timestamp, but NO data
added!
| > | > >>>>>>
| > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > | > >>>>>> permissions correct (quadruple checked by ISP admin)
| > | > >>>>>>
| > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > | > >>>>>> this, exactly same result. Not to mention, rewriting
everything
| > | > >>>>>> from scratch = ruinously expensive.
| > | > >>>>>>
| > | > >>>>>> Please Help
| > | > >>>>>>
| > | > >>>>>>
| > | > >>>>>> "LostBoy" wrote:
| > | > >>>>>>
| > | > >>>>>>> I just wanted to jump in on this conversation...I am having
the
| > | > >>>>>>> exact same problem. I am using an Access 2000 database and
| > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > | > >>>>>>> actually affecting my database.
| > | > >>>>>>>
| > | > >>>>>>> The submission form works, but does not affect the db. The
| > | > >>>>>>> delete process works, but ends with an error (can't delete
from
| > | > >>>>>>> the table), and the udate module states there is an UPDATE
| > | > >>>>>>> syntax error. All I did was use the wizard for the three
| > | > >>>>>>> modules. Any ideas?
| > | >
| > | >
| >
| >
|
|

Don · Oct 19, 2004

Yes, But the syntax is (well will be) the same / as long as you are using
access 2000. The problem is that FrontPage 2003 will create an Access 2003
database code and then rewrite the code. If you are going to modify the DB
then do it in access 2000. Import (back to FrontPage) and then verify the
query.

I know that the fpdblib.inc, fpdbrgn1.inc, and fpdbrgn2 can all be "read
only" as for the fpdbforms.inc (I don't use that) I don't see where this
would be a problem either. (making it read only)

The only other solution (as I see it) is to upgrade to Access 2003 (not what
I would want to hear)
--
Hope This Helps

Don
=====================
IEEE Degree
MS A+ Certified
StarBand Satellite Internet
FCC Certified Installer
FCC 3rd Class Lic.
Playing with FrontPage 2003 ;-)
My Playground: www.xmas-i-am.com
=====================

| Thanks for that, though I have noticed the fpdbforms.inc file is "dynamic"
| and appears to change (I presumed as a result of forms/dbs being
added/edited
| etc). If I make it read-only, wont that prevent its ability to update?
|
| "Don" wrote:
|
| > Ooops
| > For got to tell you.. To keep FrontPage 2003 from changing the code.
(once
| > it is back up and running) Change the file attributes to "Read Only"
| > --
| > Hope This Helps
| >
| > Don
| > =====================
| > IEEE Degree
| > MS A+ Certified
| > StarBand Satellite Internet
| > FCC Certified Installer
| > FCC 3rd Class Lic.
| > Playing with FrontPage 2003 ;-)
| > My Playground: www.xmas-i-am.com
| > =====================
| > | > | Thank you for that, and we may consider those avenues. However, I
note:
| > |
| > | 1) Several of the problems we have reported are of a serious code bug
| > | nature, and apparently have been known about for sometime, yet nothing
has
| > | been done.
| > |
| > | 2) Another issue is exemplified by the following: in 1997 one of our
| > staff
| > | had written to MS (via many avenues and to many locations) that the
| > animated
| > | page transitions in Office97/PowerPoint were triggering a pathological
| > | reaction since he suffers from a mild form of epilepsy. Since the
| > animation
| > | cannot be turned off, his life is a misery whenever MSPP is required.
| > |
| > | Here it is almost 8 years latter, and guess what .. is there a fix for
| > this?
| > | NO!
| > |
| > | This is only one example of many, and as you may imagine such
experiences
| > do
| > | thwart motivation, since there appears to be no benefits, but there
are
| > costs.
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > "Microsoft offers several ways for you to send comments or
suggestions
| > about
| > | > Microsoft products. If you have suggestions for product enhancements
| > that
| > | > you would like to see in future versions of Microsoft products,
please
| > | > contact us by using one of the methods listed later in this article.
| > | >
| > | > Let us know how we can improve our products.
| > | >
| > | > Product Enhancement suggestions can include: "
| > | >
| > | > http://support.microsoft.com/default.aspx?kbid=114491
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft FrontPage MVP
| > | > Spider Web Woman Designs
| > | > http://www.spiderwebwoman.com/resources/
| > | >
| > | >
| > | >
| > | > > OK I got something ... before when I replaced the FP03
fpdbforms.inc
| > | > > it
| > | > > simply resulted in FP03 overwriting my "fix" with the same FP03
inc
| > | > > file that
| > | > > I started with. Somehow or another, on further fiddling, I
managed
| > | > > to get
| > | > > the FP2K version of this inc file to "hold", then on publish it
now
| > | > > does show an error message (for the first time) and that error
| > | > > message was just about clear enough to implement a fix to the db,
and
| > | > > now it is working as expected.
| > | > >
| > | > > Now, it is our understanding that many others in many other
| > | > > locations, and
| > | > > over many months, have been struggling with this. We upgraded to
| > | > > FP03 4 days ago, so why is it that MS is still distributing
something
| > | > > that has a known (though obscure) fix (and so could have saved us
8
| > | > > man days of expenses for just this one of many FP03 quirks).
| > | > >
| > | > >
| > | > >
| > | > > "DeltaGamma" wrote:
| > | > >
| > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
instances
| > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two)
of
| > | > >> them (and it declares them twice e.g. 2 dim statements etc).
That
| > | > >> file is also approx twice the size of the equivalent file from
FP2K
| > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the
inc
| > | > >> file, after publish I look at my fpclass dir, and "lo and behold"
my
| > | > >> 2.9k inc file has magically become a 4.4k inc file.
| > | > >>
| > | > >> Also, once again, when I press submit, there are no error
messages
| > | > >> whatsoever ... everything looks fine (c.f. the thread you were
kind
| > | > >> of enough to reference, where they speak specifically of an
| > | > >> unintelligible error message which apparently they are trying to
| > | > >> make more intelligible ... or whatever ...).
| > | > >>
| > | > >> Just for â?ofunâ? I set them to True anyway, and no surprises,
the
| > | > >> results occur (i.e. form processing looks perfect, no error
| > | > >> messages, confirm page arrived as expected, mdb modified
date/time
| > | > >> consistent with submit date, â?¦ but nothing in DB!)
| > | > >>
| > | > >>
| > | > >> "Don" wrote:
| > | > >>
| > | > >>> What it is saying is, to get it to give you a better error (One
| > | > >>> that you might be able to under stand)
| > | > >>>
| > | > >>> To see the true error, open the hidden folder /_fpclass/ and
edit
| > | > >>> the fpdbrgn1.inc file
| > | > >>>
| > | > >>> At about line 19, change :
| > | > >>>
| > | > >>> fp_DEBUG = False
| > | > >>>
| > | > >>> to :
| > | > >>>
| > | > >>> fp_DEBUG = True
| > | > >>>
| > | > >>> =======================
| > | > >>> BTW: Did you try the easy fix download?
| > | > >>> Worked here...
| > | > >>> I am using FrontPage 2003 and Access 2000
| > | > >>> but have not run into the same problem you have.
| > | > >>>
| > | > >>> Hope This Helps
| > | > >>>
| > | > >>> Don
| > | > >>> =====================
| > | > >>> IEEE Degree
| > | > >>> MS A+ Certified
| > | > >>> StarBand Satellite Internet
| > | > >>> FCC Certified Installer
| > | > >>> FCC 3rd Class Lic.
| > | > >>> Playing with FrontPage 2003 ;-)
| > | > >>> My Playground: www.xmas-i-am.com
| > | > >>> =====================
message
| > | > >>> | > | > >>>> thanks for that, though that entire thread seems to discussing
| > | > >>>> some "error message" that one or another of them is seeing.
| > | > >>>>
| > | > >>>> I am not seeing any error messages. In fact that is one of my
| > | > >>>> worries, since it all appears to work, but nothing is actually
| > | > >>>> appended to the db. I have tried the suggestion of copying in
FP2K
| > | > >>>> _fpclass files, but that does not appear to help. I am not
even
| > | > >>>> sure if i had understood the exact fpclass file replacement
| > | > >>>> process. Moreover, depending on how far back I look in my
| > | > >>>> archives of FP03 and FP2k versions of ostensibly the same web,
the
| > | > >>>> fpclass files are different. In some instances the when i
changed
| > | > >>>> to older fpclass files, and saved edits in FP03, it overwrote
my
| > | > >>>> newly created "old" files, with its own new files.
| > | > >>>>
| > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > | > >>>> appalled that MS could release a bit of kit that can cause this
| > | > >>>> enormous mess. Moreover, apparently this problem has been
reported
| > | > >>>> since at least June, and here we are many months later, and the
| > | > >>>> best I could find on the MS site is to upgrade to ASP.NET ...
sure.
| > | > >>>>
| > | > >>>> Since going back to FP2K is difficult due to its
incompatibility
| > | > >>>> with 02 SE, I am inclined to follow the suggestions in one part
of
| > | > >>>> the thread . move the whole thing to Dreamweaver.
| > | > >>>>
| > | > >>>>
| > | > >>>> "Don" wrote:
| > | > >>>>
| > | > >>>>> Ted:
| > | > >>>>> You may want to read this thread:
| > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > | > >>>>> --
| > | > >>>>> Hope This Helps
| > | > >>>>>
| > | > >>>>> Don
| > | > >>>>> =====================
| > | > >>>>> IEEE Degree
| > | > >>>>> MS A+ Certified
| > | > >>>>> StarBand Satellite Internet
| > | > >>>>> FCC Certified Installer
| > | > >>>>> FCC 3rd Class Lic.
| > | > >>>>> Playing with FrontPage 2003 ;-)
| > | > >>>>> My Playground: www.xmas-i-am.com
| > | > >>>>> =====================
| > | > >>>>>
| > | > >>>>> message
| > | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > | > >>>>>> Imported/opened web originally created with FP2k, it has many
| > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
process
| > | > >>>>>> created purely using FP dbWiz etc (no coding on our part).
The
| > | > >>>>>> db works for retrieving data, so we know the connection is
good.
| > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
modified
| > | > >>>>>> date is consistent with the submit timestamp, but NO data
added!
| > | > >>>>>>
| > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > | > >>>>>> permissions correct (quadruple checked by ISP admin)
| > | > >>>>>>
| > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > | > >>>>>> this, exactly same result. Not to mention, rewriting
everything
| > | > >>>>>> from scratch = ruinously expensive.
| > | > >>>>>>
| > | > >>>>>> Please Help
| > | > >>>>>>
| > | > >>>>>>
| > | > >>>>>> "LostBoy" wrote:
| > | > >>>>>>
| > | > >>>>>>> I just wanted to jump in on this conversation...I am having
the
| > | > >>>>>>> exact same problem. I am using an Access 2000 database and
| > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > | > >>>>>>> actually affecting my database.
| > | > >>>>>>>
| > | > >>>>>>> The submission form works, but does not affect the db. The
| > | > >>>>>>> delete process works, but ends with an error (can't delete
from
| > | > >>>>>>> the table), and the udate module states there is an UPDATE
| > | > >>>>>>> syntax error. All I did was use the wizard for the three
| > | > >>>>>>> modules. Any ideas?
| > | >
| > | >
| >
| >
| >

Thomas A. Rowe · Oct 19, 2004

Have you tried open this file or any of the files in _fpclass in FP and then making a change after
you have made it read-only? If so, you will see that FP will saving any changes made to any the file
that it can open regardless if the file is marked read-only. I just tested this in FP2003.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Don said:
Not an HTML page... fpdblib.inc 8)

Don
===============
| Read-Only doesn't apply to html pages when open in FP, unless changed in
FP2003.
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| WEBMASTER Resources(tm)
|
| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| ==============================================
| To assist you in getting the best answers for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
|
| > Ooops
| > For got to tell you.. To keep FrontPage 2003 from changing the code.
(once
| > it is back up and running) Change the file attributes to "Read Only"
| > --
| > Hope This Helps
| >
| > Don
| > =====================
| > IEEE Degree
| > MS A+ Certified
| > StarBand Satellite Internet
| > FCC Certified Installer
| > FCC 3rd Class Lic.
| > Playing with FrontPage 2003 ;-)
| > My Playground: www.xmas-i-am.com
| > =====================
| > | > | Thank you for that, and we may consider those avenues. However, I
note:
| > |
| > | 1) Several of the problems we have reported are of a serious code bug
| > | nature, and apparently have been known about for sometime, yet nothing
has
| > | been done.
| > |
| > | 2) Another issue is exemplified by the following: in 1997 one of our
| > staff
| > | had written to MS (via many avenues and to many locations) that the
| > animated
| > | page transitions in Office97/PowerPoint were triggering a pathological
| > | reaction since he suffers from a mild form of epilepsy. Since the
| > animation
| > | cannot be turned off, his life is a misery whenever MSPP is required.
| > |
| > | Here it is almost 8 years latter, and guess what .. is there a fix for
| > this?
| > | NO!
| > |
| > | This is only one example of many, and as you may imagine such
experiences
| > do
| > | thwart motivation, since there appears to be no benefits, but there
are
| > costs.
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > "Microsoft offers several ways for you to send comments or
suggestions
| > about
| > | > Microsoft products. If you have suggestions for product enhancements
| > that
| > | > you would like to see in future versions of Microsoft products,
please
| > | > contact us by using one of the methods listed later in this article.
| > | >
| > | > Let us know how we can improve our products.
| > | >
| > | > Product Enhancement suggestions can include: "
| > | >
| > | > http://support.microsoft.com/default.aspx?kbid=114491
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft FrontPage MVP
| > | > Spider Web Woman Designs
| > | > http://www.spiderwebwoman.com/resources/
| > | >
| > | >
| > | >
| > | > > OK I got something ... before when I replaced the FP03
fpdbforms.inc
| > | > > it
| > | > > simply resulted in FP03 overwriting my "fix" with the same FP03
inc
| > | > > file that
| > | > > I started with. Somehow or another, on further fiddling, I
managed
| > | > > to get
| > | > > the FP2K version of this inc file to "hold", then on publish it
now
| > | > > does show an error message (for the first time) and that error
| > | > > message was just about clear enough to implement a fix to the db,
and
| > | > > now it is working as expected.
| > | > >
| > | > > Now, it is our understanding that many others in many other
| > | > > locations, and
| > | > > over many months, have been struggling with this. We upgraded to
| > | > > FP03 4 days ago, so why is it that MS is still distributing
something
| > | > > that has a known (though obscure) fix (and so could have saved us
8
| > | > > man days of expenses for just this one of many FP03 quirks).
| > | > >
| > | > >
| > | > >
| > | > > "DeltaGamma" wrote:
| > | > >
| > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
instances
| > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two)
of
| > | > >> them (and it declares them twice e.g. 2 dim statements etc).
That
| > | > >> file is also approx twice the size of the equivalent file from
FP2K
| > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the
inc
| > | > >> file, after publish I look at my fpclass dir, and "lo and behold"
my
| > | > >> 2.9k inc file has magically become a 4.4k inc file.
| > | > >>
| > | > >> Also, once again, when I press submit, there are no error
messages
| > | > >> whatsoever ... everything looks fine (c.f. the thread you were
kind
| > | > >> of enough to reference, where they speak specifically of an
| > | > >> unintelligible error message which apparently they are trying to
| > | > >> make more intelligible ... or whatever ...).
| > | > >>
| > | > >> Just for â?ofunâ? I set them to True anyway, and no surprises,
the
| > | > >> results occur (i.e. form processing looks perfect, no error
| > | > >> messages, confirm page arrived as expected, mdb modified
date/time
| > | > >> consistent with submit date, â?¦ but nothing in DB!)
| > | > >>
| > | > >>
| > | > >> "Don" wrote:
| > | > >>
| > | > >>> What it is saying is, to get it to give you a better error (One
| > | > >>> that you might be able to under stand)
| > | > >>>
| > | > >>> To see the true error, open the hidden folder /_fpclass/ and
edit
| > | > >>> the fpdbrgn1.inc file
| > | > >>>
| > | > >>> At about line 19, change :
| > | > >>>
| > | > >>> fp_DEBUG = False
| > | > >>>
| > | > >>> to :
| > | > >>>
| > | > >>> fp_DEBUG = True
| > | > >>>
| > | > >>> =======================
| > | > >>> BTW: Did you try the easy fix download?
| > | > >>> Worked here...
| > | > >>> I am using FrontPage 2003 and Access 2000
| > | > >>> but have not run into the same problem you have.
| > | > >>>
| > | > >>> Hope This Helps
| > | > >>>
| > | > >>> Don
| > | > >>> =====================
| > | > >>> IEEE Degree
| > | > >>> MS A+ Certified
| > | > >>> StarBand Satellite Internet
| > | > >>> FCC Certified Installer
| > | > >>> FCC 3rd Class Lic.
| > | > >>> Playing with FrontPage 2003 ;-)
| > | > >>> My Playground: www.xmas-i-am.com
| > | > >>> =====================
message
| > | > >>> | > | > >>>> thanks for that, though that entire thread seems to discussing
| > | > >>>> some "error message" that one or another of them is seeing.
| > | > >>>>
| > | > >>>> I am not seeing any error messages. In fact that is one of my
| > | > >>>> worries, since it all appears to work, but nothing is actually
| > | > >>>> appended to the db. I have tried the suggestion of copying in
FP2K
| > | > >>>> _fpclass files, but that does not appear to help. I am not
even
| > | > >>>> sure if i had understood the exact fpclass file replacement
| > | > >>>> process. Moreover, depending on how far back I look in my
| > | > >>>> archives of FP03 and FP2k versions of ostensibly the same web,
the
| > | > >>>> fpclass files are different. In some instances the when i
changed
| > | > >>>> to older fpclass files, and saved edits in FP03, it overwrote
my
| > | > >>>> newly created "old" files, with its own new files.
| > | > >>>>
| > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > | > >>>> appalled that MS could release a bit of kit that can cause this
| > | > >>>> enormous mess. Moreover, apparently this problem has been
reported
| > | > >>>> since at least June, and here we are many months later, and the
| > | > >>>> best I could find on the MS site is to upgrade to ASP.NET ...
sure.
| > | > >>>>
| > | > >>>> Since going back to FP2K is difficult due to its
incompatibility
| > | > >>>> with 02 SE, I am inclined to follow the suggestions in one part
of
| > | > >>>> the thread . move the whole thing to Dreamweaver.
| > | > >>>>
| > | > >>>>
| > | > >>>> "Don" wrote:
| > | > >>>>
| > | > >>>>> Ted:
| > | > >>>>> You may want to read this thread:
| > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > | > >>>>> --
| > | > >>>>> Hope This Helps
| > | > >>>>>
| > | > >>>>> Don
| > | > >>>>> =====================
| > | > >>>>> IEEE Degree
| > | > >>>>> MS A+ Certified
| > | > >>>>> StarBand Satellite Internet
| > | > >>>>> FCC Certified Installer
| > | > >>>>> FCC 3rd Class Lic.
| > | > >>>>> Playing with FrontPage 2003 ;-)
| > | > >>>>> My Playground: www.xmas-i-am.com
| > | > >>>>> =====================
| > | > >>>>>
| > | > >>>>> message
| > | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > | > >>>>>> Imported/opened web originally created with FP2k, it has many
| > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
process
| > | > >>>>>> created purely using FP dbWiz etc (no coding on our part).
The
| > | > >>>>>> db works for retrieving data, so we know the connection is
good.
| > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
modified
| > | > >>>>>> date is consistent with the submit timestamp, but NO data
added!
| > | > >>>>>>
| > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > | > >>>>>> permissions correct (quadruple checked by ISP admin)
| > | > >>>>>>
| > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > | > >>>>>> this, exactly same result. Not to mention, rewriting
everything
| > | > >>>>>> from scratch = ruinously expensive.
| > | > >>>>>>
| > | > >>>>>> Please Help
| > | > >>>>>>
| > | > >>>>>>
| > | > >>>>>> "LostBoy" wrote:
| > | > >>>>>>
| > | > >>>>>>> I just wanted to jump in on this conversation...I am having
the
| > | > >>>>>>> exact same problem. I am using an Access 2000 database and
| > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > | > >>>>>>> actually affecting my database.
| > | > >>>>>>>
| > | > >>>>>>> The submission form works, but does not affect the db. The
| > | > >>>>>>> delete process works, but ends with an error (can't delete
from
| > | > >>>>>>> the table), and the udate module states there is an UPDATE
| > | > >>>>>>> syntax error. All I did was use the wizard for the three
| > | > >>>>>>> modules. Any ideas?
| > | >
| > | >
| >
| >
|
|

Thomas A. Rowe · Oct 19, 2004

Also you will notice that the read-only attribute have been removed when FP saves the file.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thomas A. Rowe said:
Have you tried open this file or any of the files in _fpclass in FP and then making a change after
you have made it read-only? If so, you will see that FP will saving any changes made to any the file
that it can open regardless if the file is marked read-only. I just tested this in FP2003.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Don said:

Not an HTML page... fpdblib.inc 8)

Don
===============
| Read-Only doesn't apply to html pages when open in FP, unless changed in
FP2003.
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| WEBMASTER Resources(tm)
|
| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| ==============================================
| To assist you in getting the best answers for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
|
| > Ooops
| > For got to tell you.. To keep FrontPage 2003 from changing the code.
(once
| > it is back up and running) Change the file attributes to "Read Only"
| > --
| > Hope This Helps
| >
| > Don
| > =====================
| > IEEE Degree
| > MS A+ Certified
| > StarBand Satellite Internet
| > FCC Certified Installer
| > FCC 3rd Class Lic.
| > Playing with FrontPage 2003 ;-)
| > My Playground: www.xmas-i-am.com
| > =====================
| > | > | Thank you for that, and we may consider those avenues. However, I
note:
| > |
| > | 1) Several of the problems we have reported are of a serious code bug
| > | nature, and apparently have been known about for sometime, yet nothing
has
| > | been done.
| > |
| > | 2) Another issue is exemplified by the following: in 1997 one of our
| > staff
| > | had written to MS (via many avenues and to many locations) that the
| > animated
| > | page transitions in Office97/PowerPoint were triggering a pathological
| > | reaction since he suffers from a mild form of epilepsy. Since the
| > animation
| > | cannot be turned off, his life is a misery whenever MSPP is required.
| > |
| > | Here it is almost 8 years latter, and guess what .. is there a fix for
| > this?
| > | NO!
| > |
| > | This is only one example of many, and as you may imagine such
experiences
| > do
| > | thwart motivation, since there appears to be no benefits, but there
are
| > costs.
| > |
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > "Microsoft offers several ways for you to send comments or
suggestions
| > about
| > | > Microsoft products. If you have suggestions for product enhancements
| > that
| > | > you would like to see in future versions of Microsoft products,
please
| > | > contact us by using one of the methods listed later in this article.
| > | >
| > | > Let us know how we can improve our products.
| > | >
| > | > Product Enhancement suggestions can include: "
| > | >
| > | > http://support.microsoft.com/default.aspx?kbid=114491
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft FrontPage MVP
| > | > Spider Web Woman Designs
| > | > http://www.spiderwebwoman.com/resources/
| > | >
| > | >
| > | >
| > | > > OK I got something ... before when I replaced the FP03
fpdbforms.inc
| > | > > it
| > | > > simply resulted in FP03 overwriting my "fix" with the same FP03
inc
| > | > > file that
| > | > > I started with. Somehow or another, on further fiddling, I
managed
| > | > > to get
| > | > > the FP2K version of this inc file to "hold", then on publish it
now
| > | > > does show an error message (for the first time) and that error
| > | > > message was just about clear enough to implement a fix to the db,
and
| > | > > now it is working as expected.
| > | > >
| > | > > Now, it is our understanding that many others in many other
| > | > > locations, and
| > | > > over many months, have been struggling with this. We upgraded to
| > | > > FP03 4 days ago, so why is it that MS is still distributing
something
| > | > > that has a known (though obscure) fix (and so could have saved us
8
| > | > > man days of expenses for just this one of many FP03 quirks).
| > | > >
| > | > >
| > | > >
| > | > > "DeltaGamma" wrote:
| > | > >
| > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
instances
| > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes two)
of
| > | > >> them (and it declares them twice e.g. 2 dim statements etc).
That
| > | > >> file is also approx twice the size of the equivalent file from
FP2K
| > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of the
inc
| > | > >> file, after publish I look at my fpclass dir, and "lo and behold"
my
| > | > >> 2.9k inc file has magically become a 4.4k inc file.
| > | > >>
| > | > >> Also, once again, when I press submit, there are no error
messages
| > | > >> whatsoever ... everything looks fine (c.f. the thread you were
kind
| > | > >> of enough to reference, where they speak specifically of an
| > | > >> unintelligible error message which apparently they are trying to
| > | > >> make more intelligible ... or whatever ...).
| > | > >>
| > | > >> Just for â?ofunâ? I set them to True anyway, and no surprises,
the
| > | > >> results occur (i.e. form processing looks perfect, no error
| > | > >> messages, confirm page arrived as expected, mdb modified
date/time
| > | > >> consistent with submit date, â?¦ but nothing in DB!)
| > | > >>
| > | > >>
| > | > >> "Don" wrote:
| > | > >>
| > | > >>> What it is saying is, to get it to give you a better error (One
| > | > >>> that you might be able to under stand)
| > | > >>>
| > | > >>> To see the true error, open the hidden folder /_fpclass/ and
edit
| > | > >>> the fpdbrgn1.inc file
| > | > >>>
| > | > >>> At about line 19, change :
| > | > >>>
| > | > >>> fp_DEBUG = False
| > | > >>>
| > | > >>> to :
| > | > >>>
| > | > >>> fp_DEBUG = True
| > | > >>>
| > | > >>> =======================
| > | > >>> BTW: Did you try the easy fix download?
| > | > >>> Worked here...
| > | > >>> I am using FrontPage 2003 and Access 2000
| > | > >>> but have not run into the same problem you have.
| > | > >>>
| > | > >>> Hope This Helps
| > | > >>>
| > | > >>> Don
| > | > >>> =====================
| > | > >>> IEEE Degree
| > | > >>> MS A+ Certified
| > | > >>> StarBand Satellite Internet
| > | > >>> FCC Certified Installer
| > | > >>> FCC 3rd Class Lic.
| > | > >>> Playing with FrontPage 2003 ;-)
| > | > >>> My Playground: www.xmas-i-am.com
| > | > >>> =====================
message
| > | > >>> | > | > >>>> thanks for that, though that entire thread seems to discussing
| > | > >>>> some "error message" that one or another of them is seeing.
| > | > >>>>
| > | > >>>> I am not seeing any error messages. In fact that is one of my
| > | > >>>> worries, since it all appears to work, but nothing is actually
| > | > >>>> appended to the db. I have tried the suggestion of copying in
FP2K
| > | > >>>> _fpclass files, but that does not appear to help. I am not
even
| > | > >>>> sure if i had understood the exact fpclass file replacement
| > | > >>>> process. Moreover, depending on how far back I look in my
| > | > >>>> archives of FP03 and FP2k versions of ostensibly the same web,
the
| > | > >>>> fpclass files are different. In some instances the when i
changed
| > | > >>>> to older fpclass files, and saved edits in FP03, it overwrote
my
| > | > >>>> newly created "old" files, with its own new files.
| > | > >>>>
| > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I am
| > | > >>>> appalled that MS could release a bit of kit that can cause this
| > | > >>>> enormous mess. Moreover, apparently this problem has been
reported
| > | > >>>> since at least June, and here we are many months later, and the
| > | > >>>> best I could find on the MS site is to upgrade to ASP.NET ...
sure.
| > | > >>>>
| > | > >>>> Since going back to FP2K is difficult due to its
incompatibility
| > | > >>>> with 02 SE, I am inclined to follow the suggestions in one part
of
| > | > >>>> the thread . move the whole thing to Dreamweaver.
| > | > >>>>
| > | > >>>>
| > | > >>>> "Don" wrote:
| > | > >>>>
| > | > >>>>> Ted:
| > | > >>>>> You may want to read this thread:
| > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > | > >>>>> --
| > | > >>>>> Hope This Helps
| > | > >>>>>
| > | > >>>>> Don
| > | > >>>>> =====================
| > | > >>>>> IEEE Degree
| > | > >>>>> MS A+ Certified
| > | > >>>>> StarBand Satellite Internet
| > | > >>>>> FCC Certified Installer
| > | > >>>>> FCC 3rd Class Lic.
| > | > >>>>> Playing with FrontPage 2003 ;-)
| > | > >>>>> My Playground: www.xmas-i-am.com
| > | > >>>>> =====================
| > | > >>>>>
| > | > >>>>> message
| > | > >>>>>> I'd like to jump in as well. My problem is very similar. Was
| > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > | > >>>>>> Imported/opened web originally created with FP2k, it has many
| > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
process
| > | > >>>>>> created purely using FP dbWiz etc (no coding on our part).
The
| > | > >>>>>> db works for retrieving data, so we know the connection is
good.
| > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
modified
| > | > >>>>>> date is consistent with the submit timestamp, but NO data
added!
| > | > >>>>>>
| > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > | > >>>>>> permissions correct (quadruple checked by ISP admin)
| > | > >>>>>>
| > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK did
| > | > >>>>>> this, exactly same result. Not to mention, rewriting
everything
| > | > >>>>>> from scratch = ruinously expensive.
| > | > >>>>>>
| > | > >>>>>> Please Help
| > | > >>>>>>
| > | > >>>>>>
| > | > >>>>>> "LostBoy" wrote:
| > | > >>>>>>
| > | > >>>>>>> I just wanted to jump in on this conversation...I am having
the
| > | > >>>>>>> exact same problem. I am using an Access 2000 database and
| > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting is
| > | > >>>>>>> actually affecting my database.
| > | > >>>>>>>
| > | > >>>>>>> The submission form works, but does not affect the db. The
| > | > >>>>>>> delete process works, but ends with an error (can't delete
from
| > | > >>>>>>> the table), and the udate module states there is an UPDATE
| > | > >>>>>>> syntax error. All I did was use the wizard for the three
| > | > >>>>>>> modules. Any ideas?
| > | >
| > | >
| >
| >
|
|

Click to expand...

Don · Oct 19, 2004

Well, You are right! Kind of blows that theory out of the water...
Then the only thing to do is upload the file (the right one for access 2000)
and then mark the ones in the local web as "Don't Publish".

Don
===================
| Have you tried open this file or any of the files in _fpclass in FP and
then making a change after
| you have made it read-only? If so, you will see that FP will saving any
changes made to any the file
| that it can open regardless if the file is marked read-only. I just tested
this in FP2003.
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| WEBMASTER Resources(tm)
|
| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| ==============================================
| To assist you in getting the best answers for FrontPage support see:
| http://www.net-sites.com/sitebuilder/newsgroups.asp
|
| > Not an HTML page... fpdblib.inc 8)
| >
| > Don
| > ===============
| > | > | Read-Only doesn't apply to html pages when open in FP, unless changed
in
| > FP2003.
| > |
| > | --
| > | ==============================================
| > | Thomas A. Rowe (Microsoft MVP - FrontPage)
| > | WEBMASTER Resources(tm)
| > |
| > | FrontPage Resources, WebCircle, MS KB Quick Links, etc.
| > | ==============================================
| > | To assist you in getting the best answers for FrontPage support see:
| > | http://www.net-sites.com/sitebuilder/newsgroups.asp
| > |
| > | > | > Ooops
| > | > For got to tell you.. To keep FrontPage 2003 from changing the code.
| > (once
| > | > it is back up and running) Change the file attributes to "Read
Only"
| > | > --
| > | > Hope This Helps
| > | >
| > | > Don
| > | > =====================
| > | > IEEE Degree
| > | > MS A+ Certified
| > | > StarBand Satellite Internet
| > | > FCC Certified Installer
| > | > FCC 3rd Class Lic.
| > | > Playing with FrontPage 2003 ;-)
| > | > My Playground: www.xmas-i-am.com
| > | > =====================
| > | > | > | > | Thank you for that, and we may consider those avenues. However, I
| > note:
| > | > |
| > | > | 1) Several of the problems we have reported are of a serious code
bug
| > | > | nature, and apparently have been known about for sometime, yet
nothing
| > has
| > | > | been done.
| > | > |
| > | > | 2) Another issue is exemplified by the following: in 1997 one of
our
| > | > staff
| > | > | had written to MS (via many avenues and to many locations) that
the
| > | > animated
| > | > | page transitions in Office97/PowerPoint were triggering a
pathological
| > | > | reaction since he suffers from a mild form of epilepsy. Since the
| > | > animation
| > | > | cannot be turned off, his life is a misery whenever MSPP is
required.
| > | > |
| > | > | Here it is almost 8 years latter, and guess what .. is there a fix
for
| > | > this?
| > | > | NO!
| > | > |
| > | > | This is only one example of many, and as you may imagine such
| > experiences
| > | > do
| > | > | thwart motivation, since there appears to be no benefits, but
there
| > are
| > | > costs.
| > | > |
| > | > |
| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > |
| > | > | > "Microsoft offers several ways for you to send comments or
| > suggestions
| > | > about
| > | > | > Microsoft products. If you have suggestions for product
enhancements
| > | > that
| > | > | > you would like to see in future versions of Microsoft products,
| > please
| > | > | > contact us by using one of the methods listed later in this
article.
| > | > | >
| > | > | > Let us know how we can improve our products.
| > | > | >
| > | > | > Product Enhancement suggestions can include: "
| > | > | >
| > | > | > http://support.microsoft.com/default.aspx?kbid=114491
| > | > | >
| > | > | > --
| > | > | >
| > | > | > ~ Kathleen Anderson
| > | > | > Microsoft FrontPage MVP
| > | > | > Spider Web Woman Designs
| > | > | > http://www.spiderwebwoman.com/resources/
| > | > | >
| > | > | >
| > | > | >
| > | > | > > OK I got something ... before when I replaced the FP03
| > fpdbforms.inc
| > | > | > > it
| > | > | > > simply resulted in FP03 overwriting my "fix" with the same
FP03
| > inc
| > | > | > > file that
| > | > | > > I started with. Somehow or another, on further fiddling, I
| > managed
| > | > | > > to get
| > | > | > > the FP2K version of this inc file to "hold", then on publish
it
| > now
| > | > | > > does show an error message (for the first time) and that error
| > | > | > > message was just about clear enough to implement a fix to the
db,
| > and
| > | > | > > now it is working as expected.
| > | > | > >
| > | > | > > Now, it is our understanding that many others in many other
| > | > | > > locations, and
| > | > | > > over many months, have been struggling with this. We upgraded
to
| > | > | > > FP03 4 days ago, so why is it that MS is still distributing
| > something
| > | > | > > that has a known (though obscure) fix (and so could have saved
us
| > 8
| > | > | > > man days of expenses for just this one of many FP03 quirks).
| > | > | > >
| > | > | > >
| > | > | > >
| > | > | > > "DeltaGamma" wrote:
| > | > | > >
| > | > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
| > instances
| > | > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes
two)
| > of
| > | > | > >> them (and it declares them twice e.g. 2 dim statements etc).
| > That
| > | > | > >> file is also approx twice the size of the equivalent file
from
| > FP2K
| > | > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of
the
| > inc
| > | > | > >> file, after publish I look at my fpclass dir, and "lo and
behold"
| > my
| > | > | > >> 2.9k inc file has magically become a 4.4k inc file.
| > | > | > >>
| > | > | > >> Also, once again, when I press submit, there are no error
| > messages
| > | > | > >> whatsoever ... everything looks fine (c.f. the thread you
were
| > kind
| > | > | > >> of enough to reference, where they speak specifically of an
| > | > | > >> unintelligible error message which apparently they are trying
to
| > | > | > >> make more intelligible ... or whatever ...).
| > | > | > >>
| > | > | > >> Just for â?ofunâ? I set them to True anyway, and no
surprises,
| > the
| > | > | > >> results occur (i.e. form processing looks perfect, no error
| > | > | > >> messages, confirm page arrived as expected, mdb modified
| > date/time
| > | > | > >> consistent with submit date, â?¦ but nothing in DB!)
| > | > | > >>
| > | > | > >>
| > | > | > >> "Don" wrote:
| > | > | > >>
| > | > | > >>> What it is saying is, to get it to give you a better error
(One
| > | > | > >>> that you might be able to under stand)
| > | > | > >>>
| > | > | > >>> To see the true error, open the hidden folder /_fpclass/ and
| > edit
| > | > | > >>> the fpdbrgn1.inc file
| > | > | > >>>
| > | > | > >>> At about line 19, change :
| > | > | > >>>
| > | > | > >>> fp_DEBUG = False
| > | > | > >>>
| > | > | > >>> to :
| > | > | > >>>
| > | > | > >>> fp_DEBUG = True
| > | > | > >>>
| > | > | > >>> =======================
| > | > | > >>> BTW: Did you try the easy fix download?
| > | > | > >>> Worked here...
| > | > | > >>> I am using FrontPage 2003 and Access 2000
| > | > | > >>> but have not run into the same problem you have.
| > | > | > >>>
| > | > | > >>> Hope This Helps
| > | > | > >>>
| > | > | > >>> Don
| > | > | > >>> =====================
| > | > | > >>> IEEE Degree
| > | > | > >>> MS A+ Certified
| > | > | > >>> StarBand Satellite Internet
| > | > | > >>> FCC Certified Installer
| > | > | > >>> FCC 3rd Class Lic.
| > | > | > >>> Playing with FrontPage 2003 ;-)
| > | > | > >>> My Playground: www.xmas-i-am.com
| > | > | > >>> =====================
| > message
| > | > | > >>> | > | > | > >>>> thanks for that, though that entire thread seems to
discussing
| > | > | > >>>> some "error message" that one or another of them is seeing.
| > | > | > >>>>
| > | > | > >>>> I am not seeing any error messages. In fact that is one of
my
| > | > | > >>>> worries, since it all appears to work, but nothing is
actually
| > | > | > >>>> appended to the db. I have tried the suggestion of copying
in
| > FP2K
| > | > | > >>>> _fpclass files, but that does not appear to help. I am not
| > even
| > | > | > >>>> sure if i had understood the exact fpclass file replacement
| > | > | > >>>> process. Moreover, depending on how far back I look in my
| > | > | > >>>> archives of FP03 and FP2k versions of ostensibly the same
web,
| > the
| > | > | > >>>> fpclass files are different. In some instances the when i
| > changed
| > | > | > >>>> to older fpclass files, and saved edits in FP03, it
overwrote
| > my
| > | > | > >>>> newly created "old" files, with its own new files.
| > | > | > >>>>
| > | > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I
am
| > | > | > >>>> appalled that MS could release a bit of kit that can cause
this
| > | > | > >>>> enormous mess. Moreover, apparently this problem has been
| > reported
| > | > | > >>>> since at least June, and here we are many months later, and
the
| > | > | > >>>> best I could find on the MS site is to upgrade to ASP.NET
....
| > sure.
| > | > | > >>>>
| > | > | > >>>> Since going back to FP2K is difficult due to its
| > incompatibility
| > | > | > >>>> with 02 SE, I am inclined to follow the suggestions in one
part
| > of
| > | > | > >>>> the thread . move the whole thing to Dreamweaver.
| > | > | > >>>>
| > | > | > >>>>
| > | > | > >>>> "Don" wrote:
| > | > | > >>>>
| > | > | > >>>>> Ted:
| > | > | > >>>>> You may want to read this thread:
| > | > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
| > | > | > >>>>> --
| > | > | > >>>>> Hope This Helps
| > | > | > >>>>>
| > | > | > >>>>> Don
| > | > | > >>>>> =====================
| > | > | > >>>>> IEEE Degree
| > | > | > >>>>> MS A+ Certified
| > | > | > >>>>> StarBand Satellite Internet
| > | > | > >>>>> FCC Certified Installer
| > | > | > >>>>> FCC 3rd Class Lic.
| > | > | > >>>>> Playing with FrontPage 2003 ;-)
| > | > | > >>>>> My Playground: www.xmas-i-am.com
| > | > | > >>>>> =====================
| > | > | > >>>>>
in
| > | > | > >>>>> message
| > | > | > | > >>>>>> I'd like to jump in as well. My problem is very similar.
Was
| > | > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still Access2K.
| > | > | > >>>>>> Imported/opened web originally created with FP2k, it has
many
| > | > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
| > process
| > | > | > >>>>>> created purely using FP dbWiz etc (no coding on our
part).
| > The
| > | > | > >>>>>> db works for retrieving data, so we know the connection
is
| > good.
| > | > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
| > modified
| > | > | > >>>>>> date is consistent with the submit timestamp, but NO data
| > added!
| > | > | > >>>>>>
| > | > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
| > | > | > >>>>>> permissions correct (quadruple checked by ISP admin)
| > | > | > >>>>>>
| > | > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK
did
| > | > | > >>>>>> this, exactly same result. Not to mention, rewriting
| > everything
| > | > | > >>>>>> from scratch = ruinously expensive.
| > | > | > >>>>>>
| > | > | > >>>>>> Please Help
| > | > | > >>>>>>
| > | > | > >>>>>>
| > | > | > >>>>>> "LostBoy" wrote:
| > | > | > >>>>>>
| > | > | > >>>>>>> I just wanted to jump in on this conversation...I am
having
| > the
| > | > | > >>>>>>> exact same problem. I am using an Access 2000 database
and
| > | > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting
is
| > | > | > >>>>>>> actually affecting my database.
| > | > | > >>>>>>>
| > | > | > >>>>>>> The submission form works, but does not affect the db.
The
| > | > | > >>>>>>> delete process works, but ends with an error (can't
delete
| > from
| > | > | > >>>>>>> the table), and the udate module states there is an
UPDATE
| > | > | > >>>>>>> syntax error. All I did was use the wizard for the
three
| > | > | > >>>>>>> modules. Any ideas?
| > | > | >
| > | > | >
| > | >
| > | >
| > |
| > |
| >
| >
|
|

Don · Oct 20, 2004

The only other choice might be:
Saving a copy of the right pages outside of the web so in the event they are
overwritten you can then replace them with the "good" files....

This problem has been reported to MS

Don
==============================
| Well, You are right! Kind of blows that theory out of the water...
| Then the only thing to do is upload the file (the right one for access
2000)
| and then mark the ones in the local web as "Don't Publish".
|
| Don
| ===================
| || Have you tried open this file or any of the files in _fpclass in FP and
| then making a change after
|| you have made it read-only? If so, you will see that FP will saving any
| changes made to any the file
|| that it can open regardless if the file is marked read-only. I just
tested
| this in FP2003.
||
|| --
|| ==============================================
|| Thomas A. Rowe (Microsoft MVP - FrontPage)
|| WEBMASTER Resources(tm)
||
|| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
|| ==============================================
|| To assist you in getting the best answers for FrontPage support see:
|| http://www.net-sites.com/sitebuilder/newsgroups.asp
||
| || > Not an HTML page... fpdblib.inc 8)
|| >
|| > Don
|| > ===============
|| > || > | Read-Only doesn't apply to html pages when open in FP, unless changed
| in
|| > FP2003.
|| > |
|| > | --
|| > | ==============================================
|| > | Thomas A. Rowe (Microsoft MVP - FrontPage)
|| > | WEBMASTER Resources(tm)
|| > |
|| > | FrontPage Resources, WebCircle, MS KB Quick Links, etc.
|| > | ==============================================
|| > | To assist you in getting the best answers for FrontPage support see:
|| > | http://www.net-sites.com/sitebuilder/newsgroups.asp
|| > |
|| > || > | > Ooops
|| > | > For got to tell you.. To keep FrontPage 2003 from changing the
code.
|| > (once
|| > | > it is back up and running) Change the file attributes to "Read
| Only"
|| > | > --
|| > | > Hope This Helps
|| > | >
|| > | > Don
|| > | > =====================
|| > | > IEEE Degree
|| > | > MS A+ Certified
|| > | > StarBand Satellite Internet
|| > | > FCC Certified Installer
|| > | > FCC 3rd Class Lic.
|| > | > Playing with FrontPage 2003 ;-)
|| > | > My Playground: www.xmas-i-am.com
|| > | > =====================
message
|| > | > || > | > | Thank you for that, and we may consider those avenues. However,
I
|| > note:
|| > | > |
|| > | > | 1) Several of the problems we have reported are of a serious code
| bug
|| > | > | nature, and apparently have been known about for sometime, yet
| nothing
|| > has
|| > | > | been done.
|| > | > |
|| > | > | 2) Another issue is exemplified by the following: in 1997 one of
| our
|| > | > staff
|| > | > | had written to MS (via many avenues and to many locations) that
| the
|| > | > animated
|| > | > | page transitions in Office97/PowerPoint were triggering a
| pathological
|| > | > | reaction since he suffers from a mild form of epilepsy. Since
the
|| > | > animation
|| > | > | cannot be turned off, his life is a misery whenever MSPP is
| required.
|| > | > |
|| > | > | Here it is almost 8 years latter, and guess what .. is there a
fix
| for
|| > | > this?
|| > | > | NO!
|| > | > |
|| > | > | This is only one example of many, and as you may imagine such
|| > experiences
|| > | > do
|| > | > | thwart motivation, since there appears to be no benefits, but
| there
|| > are
|| > | > costs.
|| > | > |
|| > | > |
|| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
|| > | > |
|| > | > | > "Microsoft offers several ways for you to send comments or
|| > suggestions
|| > | > about
|| > | > | > Microsoft products. If you have suggestions for product
| enhancements
|| > | > that
|| > | > | > you would like to see in future versions of Microsoft products,
|| > please
|| > | > | > contact us by using one of the methods listed later in this
| article.
|| > | > | >
|| > | > | > Let us know how we can improve our products.
|| > | > | >
|| > | > | > Product Enhancement suggestions can include: "
|| > | > | >
|| > | > | > http://support.microsoft.com/default.aspx?kbid=114491
|| > | > | >
|| > | > | > --
|| > | > | >
|| > | > | > ~ Kathleen Anderson
|| > | > | > Microsoft FrontPage MVP
|| > | > | > Spider Web Woman Designs
|| > | > | > http://www.spiderwebwoman.com/resources/
|| > | > | >
|| > | > | >
|| > | > | >
|| > | > | > > OK I got something ... before when I replaced the FP03
|| > fpdbforms.inc
|| > | > | > > it
|| > | > | > > simply resulted in FP03 overwriting my "fix" with the same
| FP03
|| > inc
|| > | > | > > file that
|| > | > | > > I started with. Somehow or another, on further fiddling, I
|| > managed
|| > | > | > > to get
|| > | > | > > the FP2K version of this inc file to "hold", then on publish
| it
|| > now
|| > | > | > > does show an error message (for the first time) and that
error
|| > | > | > > message was just about clear enough to implement a fix to the
| db,
|| > and
|| > | > | > > now it is working as expected.
|| > | > | > >
|| > | > | > > Now, it is our understanding that many others in many other
|| > | > | > > locations, and
|| > | > | > > over many months, have been struggling with this. We
upgraded
| to
|| > | > | > > FP03 4 days ago, so why is it that MS is still distributing
|| > something
|| > | > | > > that has a known (though obscure) fix (and so could have
saved
| us
|| > 8
|| > | > | > > man days of expenses for just this one of many FP03 quirks).
|| > | > | > >
|| > | > | > >
|| > | > | > >
|| > | > | > > "DeltaGamma" wrote:
|| > | > | > >
|| > | > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
|| > instances
|| > | > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes
| two)
|| > of
|| > | > | > >> them (and it declares them twice e.g. 2 dim statements etc).
|| > That
|| > | > | > >> file is also approx twice the size of the equivalent file
| from
|| > FP2K
|| > | > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of
| the
|| > inc
|| > | > | > >> file, after publish I look at my fpclass dir, and "lo and
| behold"
|| > my
|| > | > | > >> 2.9k inc file has magically become a 4.4k inc file.
|| > | > | > >>
|| > | > | > >> Also, once again, when I press submit, there are no error
|| > messages
|| > | > | > >> whatsoever ... everything looks fine (c.f. the thread you
| were
|| > kind
|| > | > | > >> of enough to reference, where they speak specifically of an
|| > | > | > >> unintelligible error message which apparently they are
trying
| to
|| > | > | > >> make more intelligible ... or whatever ...).
|| > | > | > >>
|| > | > | > >> Just for â?ofunâ? I set them to True anyway, and no
| surprises,
|| > the
|| > | > | > >> results occur (i.e. form processing looks perfect, no error
|| > | > | > >> messages, confirm page arrived as expected, mdb modified
|| > date/time
|| > | > | > >> consistent with submit date, â?¦ but nothing in DB!)
|| > | > | > >>
|| > | > | > >>
|| > | > | > >> "Don" wrote:
|| > | > | > >>
|| > | > | > >>> What it is saying is, to get it to give you a better error
| (One
|| > | > | > >>> that you might be able to under stand)
|| > | > | > >>>
|| > | > | > >>> To see the true error, open the hidden folder /_fpclass/
and
|| > edit
|| > | > | > >>> the fpdbrgn1.inc file
|| > | > | > >>>
|| > | > | > >>> At about line 19, change :
|| > | > | > >>>
|| > | > | > >>> fp_DEBUG = False
|| > | > | > >>>
|| > | > | > >>> to :
|| > | > | > >>>
|| > | > | > >>> fp_DEBUG = True
|| > | > | > >>>
|| > | > | > >>> =======================
|| > | > | > >>> BTW: Did you try the easy fix download?
|| > | > | > >>> Worked here...
|| > | > | > >>> I am using FrontPage 2003 and Access 2000
|| > | > | > >>> but have not run into the same problem you have.
|| > | > | > >>>
|| > | > | > >>> Hope This Helps
|| > | > | > >>>
|| > | > | > >>> Don
|| > | > | > >>> =====================
|| > | > | > >>> IEEE Degree
|| > | > | > >>> MS A+ Certified
|| > | > | > >>> StarBand Satellite Internet
|| > | > | > >>> FCC Certified Installer
|| > | > | > >>> FCC 3rd Class Lic.
|| > | > | > >>> Playing with FrontPage 2003 ;-)
|| > | > | > >>> My Playground: www.xmas-i-am.com
|| > | > | > >>> =====================
in
|| > message
|| > | > | > >>> || > | > | > >>>> thanks for that, though that entire thread seems to
| discussing
|| > | > | > >>>> some "error message" that one or another of them is
seeing.
|| > | > | > >>>>
|| > | > | > >>>> I am not seeing any error messages. In fact that is one
of
| my
|| > | > | > >>>> worries, since it all appears to work, but nothing is
| actually
|| > | > | > >>>> appended to the db. I have tried the suggestion of copying
| in
|| > FP2K
|| > | > | > >>>> _fpclass files, but that does not appear to help. I am
not
|| > even
|| > | > | > >>>> sure if i had understood the exact fpclass file
replacement
|| > | > | > >>>> process. Moreover, depending on how far back I look in my
|| > | > | > >>>> archives of FP03 and FP2k versions of ostensibly the same
| web,
|| > the
|| > | > | > >>>> fpclass files are different. In some instances the when i
|| > changed
|| > | > | > >>>> to older fpclass files, and saved edits in FP03, it
| overwrote
|| > my
|| > | > | > >>>> newly created "old" files, with its own new files.
|| > | > | > >>>>
|| > | > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I
| am
|| > | > | > >>>> appalled that MS could release a bit of kit that can cause
| this
|| > | > | > >>>> enormous mess. Moreover, apparently this problem has been
|| > reported
|| > | > | > >>>> since at least June, and here we are many months later,
and
| the
|| > | > | > >>>> best I could find on the MS site is to upgrade to ASP.NET
| ...
|| > sure.
|| > | > | > >>>>
|| > | > | > >>>> Since going back to FP2K is difficult due to its
|| > incompatibility
|| > | > | > >>>> with 02 SE, I am inclined to follow the suggestions in one
| part
|| > of
|| > | > | > >>>> the thread . move the whole thing to Dreamweaver.
|| > | > | > >>>>
|| > | > | > >>>>
|| > | > | > >>>> "Don" wrote:
|| > | > | > >>>>
|| > | > | > >>>>> Ted:
|| > | > | > >>>>> You may want to read this thread:
|| > | > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
|| > | > | > >>>>> --
|| > | > | > >>>>> Hope This Helps
|| > | > | > >>>>>
|| > | > | > >>>>> Don
|| > | > | > >>>>> =====================
|| > | > | > >>>>> IEEE Degree
|| > | > | > >>>>> MS A+ Certified
|| > | > | > >>>>> StarBand Satellite Internet
|| > | > | > >>>>> FCC Certified Installer
|| > | > | > >>>>> FCC 3rd Class Lic.
|| > | > | > >>>>> Playing with FrontPage 2003 ;-)
|| > | > | > >>>>> My Playground: www.xmas-i-am.com
|| > | > | > >>>>> =====================
|| > | > | > >>>>>
| in
|| > | > | > >>>>> message
|| > || > | > | > >>>>>> I'd like to jump in as well. My problem is very similar.
| Was
|| > | > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still
Access2K.
|| > | > | > >>>>>> Imported/opened web originally created with FP2k, it has
| many
|| > | > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
|| > process
|| > | > | > >>>>>> created purely using FP dbWiz etc (no coding on our
| part).
|| > The
|| > | > | > >>>>>> db works for retrieving data, so we know the connection
| is
|| > good.
|| > | > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
|| > modified
|| > | > | > >>>>>> date is consistent with the submit timestamp, but NO
data
|| > added!
|| > | > | > >>>>>>
|| > | > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
|| > | > | > >>>>>> permissions correct (quadruple checked by ISP admin)
|| > | > | > >>>>>>
|| > | > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK
| did
|| > | > | > >>>>>> this, exactly same result. Not to mention, rewriting
|| > everything
|| > | > | > >>>>>> from scratch = ruinously expensive.
|| > | > | > >>>>>>
|| > | > | > >>>>>> Please Help
|| > | > | > >>>>>>
|| > | > | > >>>>>>
|| > | > | > >>>>>> "LostBoy" wrote:
|| > | > | > >>>>>>
|| > | > | > >>>>>>> I just wanted to jump in on this conversation...I am
| having
|| > the
|| > | > | > >>>>>>> exact same problem. I am using an Access 2000 database
| and
|| > | > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting
| is
|| > | > | > >>>>>>> actually affecting my database.
|| > | > | > >>>>>>>
|| > | > | > >>>>>>> The submission form works, but does not affect the db.
| The
|| > | > | > >>>>>>> delete process works, but ends with an error (can't
| delete
|| > from
|| > | > | > >>>>>>> the table), and the udate module states there is an
| UPDATE
|| > | > | > >>>>>>> syntax error. All I did was use the wizard for the
| three
|| > | > | > >>>>>>> modules. Any ideas?
|| > | > | >
|| > | > | >
|| > | >
|| > | >
|| > |
|| > |
|| >
|| >
||
||
|
|

Thomas A. Rowe · Oct 20, 2004

Another option is to learn to hand code your ASP, then those files are not used/needed.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Don said:
The only other choice might be:
Saving a copy of the right pages outside of the web so in the event they are
overwritten you can then replace them with the "good" files....

This problem has been reported to MS

Don
==============================
| Well, You are right! Kind of blows that theory out of the water...
| Then the only thing to do is upload the file (the right one for access
2000)
| and then mark the ones in the local web as "Don't Publish".
|
| Don
| ===================
| || Have you tried open this file or any of the files in _fpclass in FP and
| then making a change after
|| you have made it read-only? If so, you will see that FP will saving any
| changes made to any the file
|| that it can open regardless if the file is marked read-only. I just
tested
| this in FP2003.
||
|| --
|| ==============================================
|| Thomas A. Rowe (Microsoft MVP - FrontPage)
|| WEBMASTER Resources(tm)
||
|| FrontPage Resources, WebCircle, MS KB Quick Links, etc.
|| ==============================================
|| To assist you in getting the best answers for FrontPage support see:
|| http://www.net-sites.com/sitebuilder/newsgroups.asp
||
| || > Not an HTML page... fpdblib.inc 8)
|| >
|| > Don
|| > ===============
|| > || > | Read-Only doesn't apply to html pages when open in FP, unless changed
| in
|| > FP2003.
|| > |
|| > | --
|| > | ==============================================
|| > | Thomas A. Rowe (Microsoft MVP - FrontPage)
|| > | WEBMASTER Resources(tm)
|| > |
|| > | FrontPage Resources, WebCircle, MS KB Quick Links, etc.
|| > | ==============================================
|| > | To assist you in getting the best answers for FrontPage support see:
|| > | http://www.net-sites.com/sitebuilder/newsgroups.asp
|| > |
|| > || > | > Ooops
|| > | > For got to tell you.. To keep FrontPage 2003 from changing the
code.
|| > (once
|| > | > it is back up and running) Change the file attributes to "Read
| Only"
|| > | > --
|| > | > Hope This Helps
|| > | >
|| > | > Don
|| > | > =====================
|| > | > IEEE Degree
|| > | > MS A+ Certified
|| > | > StarBand Satellite Internet
|| > | > FCC Certified Installer
|| > | > FCC 3rd Class Lic.
|| > | > Playing with FrontPage 2003 ;-)
|| > | > My Playground: www.xmas-i-am.com
|| > | > =====================
message
|| > | > || > | > | Thank you for that, and we may consider those avenues. However,
I
|| > note:
|| > | > |
|| > | > | 1) Several of the problems we have reported are of a serious code
| bug
|| > | > | nature, and apparently have been known about for sometime, yet
| nothing
|| > has
|| > | > | been done.
|| > | > |
|| > | > | 2) Another issue is exemplified by the following: in 1997 one of
| our
|| > | > staff
|| > | > | had written to MS (via many avenues and to many locations) that
| the
|| > | > animated
|| > | > | page transitions in Office97/PowerPoint were triggering a
| pathological
|| > | > | reaction since he suffers from a mild form of epilepsy. Since
the
|| > | > animation
|| > | > | cannot be turned off, his life is a misery whenever MSPP is
| required.
|| > | > |
|| > | > | Here it is almost 8 years latter, and guess what .. is there a
fix
| for
|| > | > this?
|| > | > | NO!
|| > | > |
|| > | > | This is only one example of many, and as you may imagine such
|| > experiences
|| > | > do
|| > | > | thwart motivation, since there appears to be no benefits, but
| there
|| > are
|| > | > costs.
|| > | > |
|| > | > |
|| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
|| > | > |
|| > | > | > "Microsoft offers several ways for you to send comments or
|| > suggestions
|| > | > about
|| > | > | > Microsoft products. If you have suggestions for product
| enhancements
|| > | > that
|| > | > | > you would like to see in future versions of Microsoft products,
|| > please
|| > | > | > contact us by using one of the methods listed later in this
| article.
|| > | > | >
|| > | > | > Let us know how we can improve our products.
|| > | > | >
|| > | > | > Product Enhancement suggestions can include: "
|| > | > | >
|| > | > | > http://support.microsoft.com/default.aspx?kbid=114491
|| > | > | >
|| > | > | > --
|| > | > | >
|| > | > | > ~ Kathleen Anderson
|| > | > | > Microsoft FrontPage MVP
|| > | > | > Spider Web Woman Designs
|| > | > | > http://www.spiderwebwoman.com/resources/
|| > | > | >
|| > | > | >
|| > | > | >
|| > | > | > > OK I got something ... before when I replaced the FP03
|| > fpdbforms.inc
|| > | > | > > it
|| > | > | > > simply resulted in FP03 overwriting my "fix" with the same
| FP03
|| > inc
|| > | > | > > file that
|| > | > | > > I started with. Somehow or another, on further fiddling, I
|| > managed
|| > | > | > > to get
|| > | > | > > the FP2K version of this inc file to "hold", then on publish
| it
|| > now
|| > | > | > > does show an error message (for the first time) and that
error
|| > | > | > > message was just about clear enough to implement a fix to the
| db,
|| > and
|| > | > | > > now it is working as expected.
|| > | > | > >
|| > | > | > > Now, it is our understanding that many others in many other
|| > | > | > > locations, and
|| > | > | > > over many months, have been struggling with this. We
upgraded
| to
|| > | > | > > FP03 4 days ago, so why is it that MS is still distributing
|| > something
|| > | > | > > that has a known (though obscure) fix (and so could have
saved
| us
|| > 8
|| > | > | > > man days of expenses for just this one of many FP03 quirks).
|| > | > | > >
|| > | > | > >
|| > | > | > >
|| > | > | > > "DeltaGamma" wrote:
|| > | > | > >
|| > | > | > >> Neither of my fpdgrgn1.inc or fpdgrgn2.inc files have an
|| > instances
|| > | > | > >> of fp_DEBUG anywhere. However, my fpdbform.inc has 2 (yes
| two)
|| > of
|| > | > | > >> them (and it declares them twice e.g. 2 dim statements etc).
|| > That
|| > | > | > >> file is also approx twice the size of the equivalent file
| from
|| > FP2K
|| > | > | > >> (e.g. 4.4k vs. 2.9k). If I try to use the FP2K version of
| the
|| > inc
|| > | > | > >> file, after publish I look at my fpclass dir, and "lo and
| behold"
|| > my
|| > | > | > >> 2.9k inc file has magically become a 4.4k inc file.
|| > | > | > >>
|| > | > | > >> Also, once again, when I press submit, there are no error
|| > messages
|| > | > | > >> whatsoever ... everything looks fine (c.f. the thread you
| were
|| > kind
|| > | > | > >> of enough to reference, where they speak specifically of an
|| > | > | > >> unintelligible error message which apparently they are
trying
| to
|| > | > | > >> make more intelligible ... or whatever ...).
|| > | > | > >>
|| > | > | > >> Just for â?ofunâ? I set them to True anyway, and no
| surprises,
|| > the
|| > | > | > >> results occur (i.e. form processing looks perfect, no error
|| > | > | > >> messages, confirm page arrived as expected, mdb modified
|| > date/time
|| > | > | > >> consistent with submit date, â?¦ but nothing in DB!)
|| > | > | > >>
|| > | > | > >>
|| > | > | > >> "Don" wrote:
|| > | > | > >>
|| > | > | > >>> What it is saying is, to get it to give you a better error
| (One
|| > | > | > >>> that you might be able to under stand)
|| > | > | > >>>
|| > | > | > >>> To see the true error, open the hidden folder /_fpclass/
and
|| > edit
|| > | > | > >>> the fpdbrgn1.inc file
|| > | > | > >>>
|| > | > | > >>> At about line 19, change :
|| > | > | > >>>
|| > | > | > >>> fp_DEBUG = False
|| > | > | > >>>
|| > | > | > >>> to :
|| > | > | > >>>
|| > | > | > >>> fp_DEBUG = True
|| > | > | > >>>
|| > | > | > >>> =======================
|| > | > | > >>> BTW: Did you try the easy fix download?
|| > | > | > >>> Worked here...
|| > | > | > >>> I am using FrontPage 2003 and Access 2000
|| > | > | > >>> but have not run into the same problem you have.
|| > | > | > >>>
|| > | > | > >>> Hope This Helps
|| > | > | > >>>
|| > | > | > >>> Don
|| > | > | > >>> =====================
|| > | > | > >>> IEEE Degree
|| > | > | > >>> MS A+ Certified
|| > | > | > >>> StarBand Satellite Internet
|| > | > | > >>> FCC Certified Installer
|| > | > | > >>> FCC 3rd Class Lic.
|| > | > | > >>> Playing with FrontPage 2003 ;-)
|| > | > | > >>> My Playground: www.xmas-i-am.com
|| > | > | > >>> =====================
in
|| > message
|| > | > | > >>> || > | > | > >>>> thanks for that, though that entire thread seems to
| discussing
|| > | > | > >>>> some "error message" that one or another of them is
seeing.
|| > | > | > >>>>
|| > | > | > >>>> I am not seeing any error messages. In fact that is one
of
| my
|| > | > | > >>>> worries, since it all appears to work, but nothing is
| actually
|| > | > | > >>>> appended to the db. I have tried the suggestion of copying
| in
|| > FP2K
|| > | > | > >>>> _fpclass files, but that does not appear to help. I am
not
|| > even
|| > | > | > >>>> sure if i had understood the exact fpclass file
replacement
|| > | > | > >>>> process. Moreover, depending on how far back I look in my
|| > | > | > >>>> archives of FP03 and FP2k versions of ostensibly the same
| web,
|| > the
|| > | > | > >>>> fpclass files are different. In some instances the when i
|| > changed
|| > | > | > >>>> to older fpclass files, and saved edits in FP03, it
| overwrote
|| > my
|| > | > | > >>>> newly created "old" files, with its own new files.
|| > | > | > >>>>
|| > | > | > >>>> Quite honestly, this is a bit of "dog's breakfast", and I
| am
|| > | > | > >>>> appalled that MS could release a bit of kit that can cause
| this
|| > | > | > >>>> enormous mess. Moreover, apparently this problem has been
|| > reported
|| > | > | > >>>> since at least June, and here we are many months later,
and
| the
|| > | > | > >>>> best I could find on the MS site is to upgrade to ASP.NET
| ...
|| > sure.
|| > | > | > >>>>
|| > | > | > >>>> Since going back to FP2K is difficult due to its
|| > incompatibility
|| > | > | > >>>> with 02 SE, I am inclined to follow the suggestions in one
| part
|| > of
|| > | > | > >>>> the thread . move the whole thing to Dreamweaver.
|| > | > | > >>>>
|| > | > | > >>>>
|| > | > | > >>>> "Don" wrote:
|| > | > | > >>>>
|| > | > | > >>>>> Ted:
|| > | > | > >>>>> You may want to read this thread:
|| > | > | > >>>>> http://www.frontpagewebmaster.com/m-175524/tm.htm
|| > | > | > >>>>> --
|| > | > | > >>>>> Hope This Helps
|| > | > | > >>>>>
|| > | > | > >>>>> Don
|| > | > | > >>>>> =====================
|| > | > | > >>>>> IEEE Degree
|| > | > | > >>>>> MS A+ Certified
|| > | > | > >>>>> StarBand Satellite Internet
|| > | > | > >>>>> FCC Certified Installer
|| > | > | > >>>>> FCC 3rd Class Lic.
|| > | > | > >>>>> Playing with FrontPage 2003 ;-)
|| > | > | > >>>>> My Playground: www.xmas-i-am.com
|| > | > | > >>>>> =====================
|| > | > | > >>>>>
| in
|| > | > | > >>>>> message
|| > || > | > | > >>>>>> I'd like to jump in as well. My problem is very similar.
| Was
|| > | > | > >>>>>> using FP2k/Access2k, upgraded to FP03 but still
Access2K.
|| > | > | > >>>>>> Imported/opened web originally created with FP2k, it has
| many
|| > | > | > >>>>>> forms. E.g. one form writes to an MDB (in fpbd) via a
|| > process
|| > | > | > >>>>>> created purely using FP dbWiz etc (no coding on our
| part).
|| > The
|| > | > | > >>>>>> db works for retrieving data, so we know the connection
| is
|| > good.
|| > | > | > >>>>>> Fill form, submit, all looks perfect, the MDB's last
|| > modified
|| > | > | > >>>>>> date is consistent with the submit timestamp, but NO
data
|| > added!
|| > | > | > >>>>>>
|| > | > | > >>>>>> ISP says their FP2002 SE's etc are all up to date, all
|| > | > | > >>>>>> permissions correct (quadruple checked by ISP admin)
|| > | > | > >>>>>>
|| > | > | > >>>>>> Somebody said ... rewrite form from scratch in FP03. OK
| did
|| > | > | > >>>>>> this, exactly same result. Not to mention, rewriting
|| > everything
|| > | > | > >>>>>> from scratch = ruinously expensive.
|| > | > | > >>>>>>
|| > | > | > >>>>>> Please Help
|| > | > | > >>>>>>
|| > | > | > >>>>>>
|| > | > | > >>>>>> "LostBoy" wrote:
|| > | > | > >>>>>>
|| > | > | > >>>>>>> I just wanted to jump in on this conversation...I am
| having
|| > the
|| > | > | > >>>>>>> exact same problem. I am using an Access 2000 database
| and
|| > | > | > >>>>>>> Frontpage 2002. My updating, submitting, and deleting
| is
|| > | > | > >>>>>>> actually affecting my database.
|| > | > | > >>>>>>>
|| > | > | > >>>>>>> The submission form works, but does not affect the db.
| The
|| > | > | > >>>>>>> delete process works, but ends with an error (can't
| delete
|| > from
|| > | > | > >>>>>>> the table), and the udate module states there is an
| UPDATE
|| > | > | > >>>>>>> syntax error. All I did was use the wizard for the
| three
|| > | > | > >>>>>>> modules. Any ideas?
|| > | > | >
|| > | > | >
|| > | >
|| > | >
|| > |
|| > |
|| >
|| >
||
||
|
|

Limitation in Number of Fields ...	1	Oct 10, 2008
Data not going into database	1	Apr 2, 2008
Linking a Form to an Access Database	4	Dec 15, 2007
Database not updating	2	Jun 8, 2006
Sending an e-mail when a database is updated via a web form	11	Mar 12, 2009
Form Data Not added to Database	6	Dec 3, 2004
Database	1	Feb 24, 2008
Saving form results to database	3	Aug 22, 2007

updating database

Don

Guest

Guest

Kathleen Anderson [MVP - FrontPage]

Guest

Guest

Don

Don

Guest

Thomas A. Rowe

Guest

Don

Don

Thomas A. Rowe

Thomas A. Rowe

Don

Don

Thomas A. Rowe

Ask a Question

Similar Threads