Memo fields

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!

Re: Memo fields

"christianlott1@yahoo.com" wrote:

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

Re: Memo fields

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

Re: Memo fields

christianlott1@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.

Re: Memo fields

"christianlott1@yahoo.com" wrote in
news:34efd651-9785-4db4-a435-ae136f4a54dd@c4g2000hsg.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.

Re: Memo fields

lyle fairfield wrote:
> "christianlott1@yahoo.com" wrote in
> news:34efd651-9785-4db4-a435-ae136f4a54dd@c4g2000hsg.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.

Re: Memo fields

"christianlott1@yahoo.com" wrote in
news:3d1b4fe2-4b15-4706-969a-0dc9bf6e69b6@41g2000hsy.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

Re: Memo fields

Bob Quintal wrote:
> "christianlott1@yahoo.com" wrote in
> news:3d1b4fe2-4b15-4706-969a-0dc9bf6e69b6@41g2000hsy.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.

Re: Memo fields

"christianlott1@yahoo.com" wrote in
news:46ef8290-5035-4f68-ae71-5d3fab646462@e6g2000prf.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.

Re: Memo fields

On Jan 4, 1:56 pm, lyle fairfield wrote:
> "christianlo...@yahoo.com" wrote innews:46ef8290-5035-4f68-ae71-5d3fab646462@e6g2000prf.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.

Re: Memo fields

"christianlott1@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."

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/

Re: Memo fields

On Jan 7, 8:14 pm, "Tony Toews [MVP]" wrote:
> "christianlo...@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."
>
> 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.