Connecting Tech Pros Worldwide Help | Site Map

HELP: Access record ID's corrupted by WWW insert and updates, memo field may be culprit

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 11:57 PM
htmlgeek
Guest
 
Posts: n/a
Default HELP: Access record ID's corrupted by WWW insert and updates, memo field may be culprit

I'm adding and updating records in an Access .mdb via WWW .asp page.
Authored in Dreamweaver 2004 MX.

Help is welcome on this one. I have a great set of pages that work
fine, but it seems that insert or update pages don't always work now
on some records . . .

It seems that when lots of text is shoved into a memo fields the
database ID for that record gets messed up. Intial record insertion
goes OK, but updating is then hosed.

Insert and update pages work OK, and "most" records will update. The
strange error I'm getting is:

--------------

Microsoft JET Database Engine error '80004005'

The search key was not found in any record.

------------

While pages still display the records on the WWW, the record ID is
glitched up in such a way that you can not longer edit the record . .
.. upon submission you get and errors like 'search ID not found in any
record.'

I'm told this may have to do with the field order in Access and upon
the submission page.

Has anyone run into this? Solution has something to do with moving the
memo fields to be listed last in Access and submitted last from the
WWW.

Have you ever heard of field order mattering upon insert and/or update
of WWW submissions to an Access database . . . where memo fields are
best to be at the end of the submission order . . . otherwise they may
glitch up the existing records upon updating?

I've had a couple sites where the ID key of records gets corrupted in
Access and I can no longer update certain records and need to run
compact/repair to get the dbase back to normal. But, the problem
re-occurs.

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.