I've beaten my head againts this for two weeks and would appreciate any help.

I've rebuilt pages etc. etc.

Insert and update work, but updating of records with data in the memo field seem to crash/corrupt Access--but only on those records.

The problem seems to narrow down to updating a record's memo field. It works once or twice, then Access becomes corrupt -- yet the records without memo field data work.

WWW error notes 'search key not found in any record'.

The errors are consistent. Compact/repair of Access is only a temporary fix--and yields a note that 'user unexpectantly closed Access while still in use'.

I've moved the memo field to the end of the ASP code so it's the last item, but this didn't solve the problem.

I've upgraded to MS Access 2003 and MDAC 2.8 etc. etc.

HELP!

This may shed light on the problem, that somehow, maybe indirectly was linked with Adv HTML

forums.aspfree.com/t18419/s.html

Seems a space in an Access field name caused the corruption, but was inconsistent . . . and showed only on records with large text in Adv HTML field (though it was named fine . . .)

Very odd.


Edited by - bbrammer on 23 Jun 2004 19:24:17

bob i appreciate your trying to get something fixed, but stop posting this question in different formats in different forums, its spamming, and no-one likes spamming.

Regards,
Dave

<img src="www.nova-cs.co.uk/DmxAvatar.jpg" border="0">" border=0>

[DWMX 2004]|[FlashMX 2004 Pro]|[SQL]|[Access2000]|[ASP/VBScript]|[XP-Pro]

Hi,

I think you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files. Its web address is www.datanumen.com/aar/

Just post to hope this will help in the future.

Alan


fyz

Quote

I've beaten my head againts this for two weeks and would appreciate any help.

I've rebuilt pages etc. etc.

Insert and update work, but updating of records with data in the memo field seem to crash/corrupt Access--but only on those records.

The problem seems to narrow down to updating a record's memo field. It works once or twice, then Access becomes corrupt -- yet the records without memo field data work.

WWW error notes 'search key not found in any record'.

The errors are consistent. Compact/repair of Access is only a temporary fix--and yields a note that 'user unexpectantly closed Access while still in use'.

I've moved the memo field to the end of the ASP code so it's the last item, but this didn't solve the problem.

I've upgraded to MS Access 2003 and MDAC 2.8 etc. etc.

HELP!

For working out present condition you may use recovery for access. It has many various features such as working under all popular Windows OS, using modern methods of recovering mdb data. The tool doesn't modify source access data during restoration.

Thanks it is solved.

I have a form. In that form, I have a combo box, which stores the 'memo reference'. I also have the 'memo reference' field in that form for data entry purpose.
VistaPrint Coupons

may be it is problem of database of php admin, system .
check your file
promo codes
SEO Company