Error on save

  • Thread starter Thread starter Simon Harris
  • Start date Start date
S

Simon Harris

Hi All,

I have a form which has a field bound to a column in a table with a memo
data type.

My user has entered a fair amount of data (2677 Chars) but no where near the
published 65k limit for memo fields.

When they open the record, they can save it Ok IF they make no changes to
the field containing the memo field. If they delete or add even one
character, then save they get the following error:

"Could not update; currently locked by another session on this machine"

Data in other fields on the same form can be edited without effecting the
save.

This occurs on both Windows 98 running Acccess 2000 SP3 and on a Windows XP
machine running office XP SP2. It only happens on 3 records so far - All
others are AOK.

Any help or ideas would be much appreaicted...This is the only remaining bug
on this database!! :)


Thanks!
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
 
| Hi All,
|
| I have a form which has a field bound to a column in a table with a memo
| data type.
|
| My user has entered a fair amount of data (2677 Chars) but no where near
the
| published 65k limit for memo fields.
|
| When they open the record, they can save it Ok IF they make no changes to
| the field containing the memo field. If they delete or add even one
| character, then save they get the following error:
|
| "Could not update; currently locked by another session on this machine"
|
| Data in other fields on the same form can be edited without effecting the
| save.
|
| This occurs on both Windows 98 running Acccess 2000 SP3 and on a Windows
XP
| machine running office XP SP2. It only happens on 3 records so far - All
| others are AOK.
|
| Any help or ideas would be much appreaicted...This is the only remaining
bug
| on this database!! :)
----------
Hi Simon,

This is a known bug when you try to edit a memo field when two or more
instances of the same form are open. See if this is what you have.

Hope this helps,
 
Thanks Eric, but it doesnt seem to be that. I only have one instance of the
form open.

Any other ideas?

Regards,

Simon.
 
Back
Top