I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008. M$ rocks!
11  2539 
"ch************ @yahoo.com" <ch************ @yahoo.comwrote :
>I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008. M$ rocks!
What problem(s) are you encountering?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."
ch************@ yahoo.com wrote:
"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."
That means that there is a corrupt field in your database.
"ch************ @yahoo.com" <ch************ @yahoo.comwrote in
news:34******** *************** ***********@c4g 2000hsg.googleg roups.com:
I really think it's a shame ms access has such a buggy memo field :(
Possibly someone with your expertise and experience could make some
suggestions about how to improve it.
A database that can't store even a paragraph of contiguous text in
2008.
What's contiguous text? What's non-contiguous text?
M$ rocks!
Some people, after having worked with databases and programming and
application development for more than twenty-five years, after exploring
other operating systems, after trying to poke fun at Bill and MS for a long
time, have concluded that it does.
I am one of those persons.
PS. During my experiences I have learned what a memo field is, how it works
and why JET/ACE may misinterpret the instructions of SQL strings that
reference memo fields. This has helped me to have zero problems with memo
fields over the past several years.
lyle fairfield wrote:
"ch************ @yahoo.com" <ch************ @yahoo.comwrote in
news:34******** *************** ***********@c4g 2000hsg.googleg roups.com:
I really think it's a shame ms access has such a buggy memo field :(
Possibly someone with your expertise and experience could make some
suggestions about how to improve it.
don't randomly break? work like a text field, just hold more
characters?
since ms access is not open source, i think we're going to have to
wait till 3020 or therabouts for ms to fix it.
A database that can't store even a paragraph of contiguous text in
2008.
What's contiguous text? What's non-contiguous text?
if i have a paragraph of text i don't want to have to split it into
multiple text fields to store it??
M$ rocks!
Some people, after having worked with databases and programming and
application development for more than twenty-five years,
yawn!
after exploring
other operating systems,
im getting sleepy...
after trying to poke fun at Bill and MS for a long
time, have concluded that it does.
I am one of those persons.
good for you! you haven't helped me a bit! congratulations !
PS. During my experiences I have learned what a memo field is, how it works
and why JET/ACE may misinterpret the instructions of SQL strings that
reference memo fields. This has helped me to have zero problems with memo
fields over the past several years.
are you hinting that there MIGHT be a problem??
it's a free country but i'd rather you didn't respond to any of my
posts. thanks.
"ch************ @yahoo.com" <ch************ @yahoo.comwrote in
news:3d******** *************** ***********@41g 2000hsy.googleg roups.com:
"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."
Ok, so are you the only user of the database? Is it possible that there
is another user attempting to edit an adjacent record at the time you
are editing yours?
Are you attempting to update the memo field using an SQL update query
while the table is opened for editing by you in a form?
These are situations which may cause the error message you complain
about. If it is a bug, it is likely in your code, not MS-Access code.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
Bob Quintal wrote:
"ch************ @yahoo.com" <ch************ @yahoo.comwrote in
news:3d******** *************** ***********@41g 2000hsy.googleg roups.com:
"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."
Ok, so are you the only user of the database?
the only user of that form and that particular table.
Is it possible that there
is another user attempting to edit an adjacent record at the time you
are editing yours?
nope.
Are you attempting to update the memo field using an SQL update query
while the table is opened for editing by you in a form?
no.
These are situations which may cause the error message you complain
about. If it is a bug, it is likely in your code, not MS-Access code.
there is no code behind it.
it says it can't save the record at this time, the field becomes
"#deleted#" .
the error message pops up multiple times so you have to close all the
error messages that keep coming up quickly then close the form. upon
returning to the record, the original typed text is there - it was not
deleted.
looking at it again it might be this right join. thanks for your help.
"ch************ @yahoo.com" <ch************ @yahoo.comwrote in
news:46******** *************** ***********@e6g 2000prf.googleg roups.com:
good for you! you haven't helped me a bit! congratulations !
Did you ask for help? I must have missed that. Let me check:
I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008. M$ rocks!
Dang! Still can't see it.
On Jan 4, 1:56 pm, lyle fairfield <lylef...@yah00 .cawrote:
"christianlo... @yahoo.com" <christianlo... @yahoo.comwrote innews:46****** *************** *************@e 6g2000prf.googl egroups.com:
good for you! you haven't helped me a bit! congratulations !
Did you ask for help? I must have missed that. Let me check:
i DID ask you to stop responding.
>
I really think it's a shame ms access has such a buggy memo field :(
A database that can't store even a paragraph of contiguous text in
2008. M$ rocks!
Dang! Still can't see it.
i'm not surprised. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jeremy |
last post by:
I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.
The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming...
|
by: ken |
last post by:
I have 5 memo fields in one of my tables. I need to add 7 more. Will
this be a problem? Am I being paranoid?
Thanks
|
by: jacoballen |
last post by:
I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as DISTINCT and
GROUPBY will fix this problem (as discussed in other threads in this
group), but I need to limit the query results to unique values, which
is what DISTINCT does for me. Any suggestions?
Thanks,
Jacob
|
by: maffonso |
last post by:
Hi guys,
My table has a memo field. At the end of the month a run
a report and I would like to concatenate the memo fields in a unique
field by
dept. Im thinking doing this through totals button , but in the
combobox
there are only max,min,sum,.. There is no concatenate function.
Im avoinding doing that using VBA.
Somebody help me please.
|
by: midlothian |
last post by:
Does using CStr on a memo field truncate it to 255 characters? Seems
like this is happening with some data in my tables. Is there a way
around this?
| | |
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
|
by: kaplan.gillian |
last post by:
Hi everyone,
I currently have an Access database that includes quite a few
long memo fields. When I create a report of my data, Access
does not allow the memo fields to be split with the page breaks.
In other words, if my memo field is 3 paragraphs long and there
is only space on a report page for 2 paragraphs, rather than
putting 2 paragraphs on one page and the last one on the next
page, all 3 paragraphs are moved to the next page...
|
by: ARC |
last post by:
This is mainly a speed question.
In this example: I have a QuotesHdr table that has a few memo fields. If
these memo fields are used extensively by some users, and if their are a
large number of records in QuotesHdr, should I break out the memo fields
into a separate table? The thinking here is that, for Quotes selection
dropdowns that display all entries in QuotesHdr for selection, I would think
that the entire record comes down over...
|
by: steph |
last post by:
I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that vary
based on user selections. The input files are CSVs and can number from
2 to 175 columns. Each field is usually able to fit into a Text field
(< 255 characters) but every now and then a longer field creeps in.
since I don't know in which column...
|
by: Wayne |
last post by:
I've been asked to construct a database which will require several
memo fields. This database will be the standard frontend/backend mdb
configuration. I have read many posts describing the corruption
problems associated with memo fields, especially in a networked
environment. Am I asking for trouble if I go ahead with this project?
|
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...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
