Re: db editor

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kathleen Anderson [MVP - FrontPage] (spiderwebwoman_at_mvps.org)
Date: 02/03/05 

Date: Wed, 2 Feb 2005 21:03:26 -0500

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?
>> >
>> >
>> >

Relevant Pages

  • Re: db editor
    ... The change from the initial database to now was the ... > I can edit the fields of existing records and the updates are reflected - I ... > I recreated the whole db interface several times - even created a new web ... >> Spider Web Woman Designs ...
    (microsoft.public.frontpage.programming)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)
  • Re: Disk transfers
    ... database software rather than in the application itself) is to capture the change in a relatively small update record in a log - which can be supported effectively in a relatively small amount of NVRAM if performance is important, rather than throwing GB of NVRAM at a generic disk write-back cache, and which in any event can effectively batch many such updates into a single log write if they occur very close to each other - and then later perform the eventual on-disk structural updates lazily, in the background, and possibly in bulk. ... though I'm not sure how the latter would vary all that much (unless you're just referring to the difference between disk and NVRAM performance). ...
    (comp.arch)