db editor

[MaureenKLM]

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?

 

[Kathleen Anderson [MVP - FrontPage]]

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]

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?

 

[MaureenKLM]

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!

 

[Kathleen Anderson [MVP - FrontPage]]

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