Kathleen
Wed Feb 02 20:03:26 CST 2005
Maureen:
You're right - you did misunderstand me - thanks for coming back and
clarifying :-) The steps you took are normally along the same lines of
what I would have done after adding new fields to a database. I normally
delete the existing database, delete the fpdb folder, delete the files in
_fpclass and the __fpclass folder and also delete the global.asa. Then I
start over by reimporting the database, letting it recreate everything and
then start creating new pages. I'm not sure why this didn't work for you.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
"MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
news:F3E55A57-C1FA-405D-B0E4-007E58A107FC@microsoft.com...
>I may have misunderstood your question about "updates" -
>
> The change from the initial database (when delete worked) to now was the
> simple addition of ONE TEXT FIELD - that's it.
>
> I am able to delete records from within the db myself but that won't work
> once the site is in production - If there was something I did when I added
> the new field to the DB then recreating the website, creating a new DNS,
> and
> generating new DBI pages should have resolved that. I'm totally puzzled -
> I
> really hope you can offer some solutions and insights into what could be
> wrong. THANK YOU!
>
>
> "MaureenKLM" wrote:
>
>> I was able to enter new records using the submission form - records are
>> comprised of the Primary Key ID field which is text , required = yes,
>> zero
>> length = no; 11 more text fields, all not required. zero length = YES,
>> lastly a Yes/No field which is NOT required. Nothing fancy here.
>>
>> The DSN is directed to the table directly, not a query.
>>
>> I can edit the fields of existing records and the updates are reflected -
>> I
>> just can not DELETE records and there is no error message to help direct
>> me.
>>
>> I recreated the whole db interface several times - even created a new web
>> and created it in there - for some reason the DB interface delete record
>> option is not working. Any clues?
>>
>>
>>
>> "Kathleen Anderson [MVP - FrontPage]" wrote:
>>
>> > What kind of updates did you make to the database?
>> >
>> > --
>> > ~ Kathleen Anderson
>> > Microsoft MVP - FrontPage
>> > Spider Web Woman Designs
>> > web:
http://www.spiderwebwoman.com/resources/
>> > blog:
http://msmvps.com/spiderwebwoman/category/321.aspx
>> >
>> >
>> >
>> > "MaureenKLM" <MaureenKLM@discussions.microsoft.com> wrote in message
>> > news:18CEADD6-5450-45B8-B3D9-9AEA956C0256@microsoft.com...
>> > >I have a FP 2002 web with an Access 2002 DB - Records in the DB have a
>> > > Primary Key set to accept text, required = YES, allow zero length =
>> > > NO.
>> > >
>> > > Created admin pages for the DB records using the FP DBIW - all worked
>> > > until
>> > > I had to update the DB and then recreate the DBIW admin pages...
>> > >
>> > > I can now add and edit records, but the DELETE does not actually
>> > > delete
>> > > any
>> > > records although I get a confirmation that it processed - there are
>> > > no
>> > > error
>> > > messages received.
>> > >
>> > > The records in the DB are not related to anything so that's not a
>> > > cause -
>> > >
>> > > Any helpful suggestions of where I should look to solve this problem?
>> >
>> >
>> >