Nancy,

Actually it's the opposite switching to row buffering minimized the "table is in use" error (although sometimes it appears). And yes the grid uses multiple table. It's a real headache :).


>This drove me _nuts_ when I started using grids. I've moved away from using grids to edit data (use textboxes above the grid to edit, and use the grid to navigate). I *think* switching to using table buffering (rather than row) helped. Do you have multiple tables being updated in your grid? is your grid source a view?
>
>
>>i'm trying to look for the cause of this randomly occuring grid problem - record is in use by another user.
>>
>>i tries unlock in the error event, didn't work.
>>
>>Any suggestions? TIA