Memo fields

[christianlott1]

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!

[Tony Toews [MVP]]

"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/

[christianlott1]

"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."

[Bob Alston]

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.

[lyle fairfield]

"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:34**********************************@c4g2000h sg.googlegroups.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.

[christianlott1]

lyle fairfield wrote:

"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:34**********************************@c4g2000h sg.googlegroups.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.

[Bob Quintal]

"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:3d**********************************@41g2000h sy.googlegroups.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

[christianlott1]

Bob Quintal wrote:

"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:3d**********************************@41g2000h sy.googlegroups.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.

[lyle fairfield]

"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:46**********************************@e6g2000p rf.googlegroups.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.

[christianlott1]

On Jan 4, 1:56 pm, lyle fairfield <[e-mail]:

"[e-mail]" <[e-mail] innews:46**********************************@e6g200 0prf.googlegroups.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.

[Tony Toews [MVP]]

"ch************@yahoo.com" <ch************@yahoo.comwrote:

>"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."

This and your description of the file indicated that the memo field has become
corrupt. Try deleting that record and re-eintering it.

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/

[christianlott1]

On Jan 7, 8:14 pm, "Tony Toews [MVP]" <[e-mail]:

"[e-mail]" <[e-mail]:

"The Jet engine stopped the process because you and another user are
attempting to change the same data at the same time."

This and your description of the file indicated that the memo field has become
corrupt. Try deleting that record and re-eintering it.

Yes, but this happens frequently.

This describes it:
http://support.microsoft.com/kb/235391/en-us

but the record is not deleted even though it says so. The longer it
sits there, the more of the same error message keeps popping up. Close
the error messages and move off the record, when you return the
original memo entry is there. No corruption, no deletion.

This has been going on for months. It's not a complex join, there's no
code that updates the record, and I have msjet40.dll.