473,406 Members | 2,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

HELP! Web update of memo field crashes Access, errors repeatable. HELP!

I've beaten my head againts this for two weeks and would appreciate
any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000
and then 2003 and received same problems!

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. And the database and display pages still
work.

Upon update attempt I get a 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!
Nov 13 '05 #1
0 1620

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: euang | last post by:
Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying...
0
by: Lauren Wilson | last post by:
The error does not have an error number. It's not even a normal Access error message box. Hope someone has some insight to this problem. I have a form that contains a large (5" x 4") text box...
1
by: microsoft.public.dotnet.languages.csharp | last post by:
I am trying to insert a record into an Access database that has a memo field. It keeps giving me an error. I am using C#, Access 2000 and OleDB. Anyone know what the trick is to doing this?...
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
1
by: Brook | last post by:
Hi, I have a form set up (frm_enter_action) which has an unbound text box on it (description) allowing users to enter standard text. This field is then used to insert a record into a table...
4
by: Folu | last post by:
Hello, Please how do I convert formatted text in a word document into markedup text in a memo field in MSaccess, and retain the formatting. I have created a form to display the contents of a word...
0
by: David | last post by:
Hello! We are using Access 2000, SQL Server 2000. We are using a simple append query to append data from an unbound form field to an SQL Server linked table. The field in Access is a memo field,...
8
by: pteare | last post by:
Hello, I was wondering if someone might be able to help me. I’m a little stuck as to how to put the results of a query into a memo field. I run a ski chalet company and I have a bookings...
0
by: vba challenge | last post by:
I have a Salary table(The one side) and a Deductions table(The Many side). Whenever the salary is entered I want to calculate and store the deductions in the deductions table. I know...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.