This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Dreamweaver » HELP, update of memo field in Access crashing mdb

HELP, update of memo field in Access crashing mdb
Bob Brammer Member Since: 07 Jan 2002 Posts: 16	Posted 20 Jun 2004 21:07:49 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! 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!

HELP, update of memo field in Access crashing mdb

Bob Brammer
Member

Since: 07 Jan 2002
Posts: 16

Posted 20 Jun 2004 21:07:49

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!

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!

Bob Brammer Member Since: 07 Jan 2002 Posts: 16	Replied 23 Jun 2004 19:19:24 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

Dave Thomas Zone Administrator Since: 02 Jul 2002 Posts: 1,216	Replied 23 Jun 2004 20:53:46 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]

Alan Chen Member Since: 30 Apr 2008 Posts: 2	Replied 02 May 2008 15:23:50 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

Alex Krenvalk Member Since: 04 Mar 2010 Posts: 2	Replied 06 Sep 2011 21:16:40 QuoteI'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.