Invalid Bookmark error - Record in use

[tbclbd]

Msg#1 INVALID BOOKMARK

I have a simple Sales Order form with a subform for items, qty & price.

Recently we're getting an Invalid Bookmark error (Bookmark command is not used in code). Occasionally a "Jet DB Engine Stopped .. record in use by another user" error (even though no one else is on system).

The pgm was written in A97 but recently moved to A2000 on WinXP. It works fine 90% of the time. I have Jet sp7 installed.

I am looking for suggestions on how to rroubleshoot/trap this error to see where it is coming from. Looks like it's occuring on the subform AfterUpdate.

Any ideas of how to troubleshoot/resolve is greatly appreciated.

Thanks in advance.


Msg#2
Two more points of info regarding this subform.
When I get the Jet DB Engine Stopped.. record in use..., the subform BeforeUpdate procedure completed but the AfterUpdate did not begin.

There is also an AfterUpdate that runs from an Inventory Item ComboBox:

 

[antchong]

Hi tbclbd
I aslo ahving the same problam as u did u found out how to fix it???...

 

[MakeItSo]

Hi Guys,

1)Have you set the Lock Edits property of the form to TRUE?
If yes, this might cause the problem.

2)I assume, the BeforeUpdate event updates inventory information for the current record or sth like that.
How is it done? Do you call a module?
If yes: Check in what way the recordset is opened and handled in the module.

3) I am not familiar with access xp, but there is certainly a big difference to 97 when it comes to recordset locking.
I don't know, if there has been a change in the preferred uses of DAO/ADO, so you could also try changing the reference from DAO to ADO and see if that removes the error.

Hope this helps,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos