473,675 Members | 3,629 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1628

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

Similar topics

8
5788
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 information from MEMO fields within the Access 2000 database. I have not had any problems before displaying MEMO fields on NT and have tried various tips to resolve this issue but no luck so far. I was wondering if anyone had come accross a similar...
0
1375
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 bound to a memo field. This field allows users to type in the text of an email to be sent through Outlook (via automation). I ONE user who send me his back end data base where he has inserted several two - three page emails. When scrolling...
1
521
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? Thanks, Marty
9
5731
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 field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006
1
2211
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 (tbl_cases_actions) using the following SQL statement :- INSERT INTO (description) Values (Forms!frm_enter_action.description) The text appears to be truncated in the table at 512 characters when brought into the description field, which is set as...
4
4936
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 document, and intend to use Leban's RTF2 control to view the file's contents. Your response will be most valued.
0
2183
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, and in SQL Server it is an nText field. However, some of the text gets garbled at the end of long entries (approx. 510 characters.) An example of this follows: The quick brown fox jumps over the lazy dog. The...
8
4329
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 database. In this I store all the emails that go back and forth with my guests, these are stored in a memo field. I’m trying to make a system to template my emails for me. Ideally I’d like it to template and email that has a list of all the extras...
0
1049
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 calculations should be done in queries but I want to store the calculated deductions because the tax system changes pretty often so I want individual tax calculations for each paycheck to be stored. I can write code use macros and design queries. I am...
0
8515
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8863
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8717
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7499
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6275
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4259
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4464
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2864
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2120
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.