ERROR MESSAGE:

[LEX]

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

Can someone help me figure out why access gives me this error on some
record's memo fields but not on others?

[Barry Edmund Wright]

Re: ERROR MESSAGE:

Lex,

Go to Tools/Options and on the "Advanced" tab and set the Default Open
Mode to "Shared", the Default Record Locking to "No Locks" and check
the "Open Databases using record-level locking" box.

Cheers,
Barry


On Jun 6, 11:23 am, LEX <i...@grantsint ernational.comw rote:

Could not update; currently locked by another session on this
machine.
>
Can someone help me figure out why access gives me this error on some
record's memo fields but not on others?

[LEX]

Re: ERROR MESSAGE:

HERE IS SOME BACKGROUND

I have the following objects:
Table1 - HO (which has about 51,000+ records)
Table2 - Contact (which has 68,000+ records)
Table3 - Notes (which has 69,000+ records)


They are linked in the relationships as a "1 to many" relationship
with cascading changes and deletes based on the company name in the
HO
Table being the "1" and the company name in the Contact and Notes
tables being the many.


FORMS
So I created a MAIN form based on the HO table and on that form I
have
2 x SUB forms that link as parent and child fields on the same
company
name field in the Contact and Notes tables. The sub forms have only
a
few fields from each record that show up and the)y are set up as
"Continuous Forms" in the "default view" property of the subform so
that multiple records will show up on the main form allowing our
people to see the essential information about each of the subcontacts
of the HO and the multiple notes (if the company indentified in the
HO
table has many of them).


When you double click any of the fields in either of the sub forms,
It
runs a macro that open another form "BIG NOTES" (with a default view
property of "single form" which has all the remaining fields for that
record in the corresponding subform.


THE PROBLEM - (and this is Bizzarre and why I need help)
If I edit the memo field in the subform on the MAIN form, I have no
errors BUT
if I edit the memo field in the BIG NOTES form when I close it I get
the error message
"Could not update; currntly locked by another session on this
machine."
Note that this is NOT for all the records in the database, it is
happening only to a selct few of them.
Stranger yet,
I can edit other non-memo fields in this form and I DO NOT get any
error message.
Stranger yet,
If I add another record to the notes, I can edit the memo field in
the first record, buit if I then delete that second record, I get the
error message again in the first record
Stranger Yet,
If I close the MAIN form, I cen edit the memo field in the BIG
NOTES
Form


Any help would be greatly appreciated.


Thanks,






On Jun 6, 10:33 pm, Barry Edmund Wright
<bwright_msacc. ..@sympatico.ca wrote:

Lex,
>
Go to Tools/Options and on the "Advanced" tab and set the Default Open
Mode to "Shared", the Default Record Locking to "No Locks" and check
the "Open Databases using record-level locking" box.
>
Cheers,
Barry
>
On Jun 6, 11:23 am, LEX <i...@grantsint ernational.comw rote:
>
>
>

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

>

Can someone help me figure out why access gives me this error on some
record's memo fields but not on others?- Hide quoted text -

>
- Show quoted text -