Re: Edited by another user..?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Kent.

Kent J. wrote:
Hi,
I get the odd message when I try to edit a record in a SQL-server
table: 'The record is edited by another user....' I know that I'm
the only one editing the record. I have tried to restart Access
but been unsuccessful.
What can be wrong?

Maybe you have opened a recordset in the background and did not
close it before editing the record.
Or you have a form with a subform and have the same record in the
main and subform (sometimes, people do this...).
You can use SQL Profiler to find out what your frontend does.

--
Regards,
Wolfgang


.

Relevant Pages

  • Re: Subform ?
    ... you're supposed to be able to edit the subform my ... opening the main form and editing the subform in place. ...
    (microsoft.public.access.formscoding)
  • Cannot enable editing of some fields
    ... I cannot seem to be able to allow editing of some fields on a subform. ... I changed the properties to Enabled and Locked; but I am still unable to edit the desired fields? ...
    (microsoft.public.access.forms)
  • Re: Form design to add new record when subforms exist
    ... haven't declared rstData at module level for the form. ... procedure in both the EditRecord form and its subform. ... Could you clarify this for me: When I click my Edit button on my ... record) occurs when I click a Save or Cancel. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form design to add new record when subforms exist
    ... How and where do I declare rst.Data as a Public variable? ... You could have rstData opened by one form and closed by another, ... procedure in both the EditRecord form and its subform. ... Could you clarify this for me: When I click my Edit button on my ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form design to add new record when subforms exist
    ... You could have rstData opened by one form and closed by another, ... procedure in both the EditRecord form and its subform. ... Could you clarify this for me: When I click my Edit button on my ... record) occurs when I click a Save or Cancel. ...
    (microsoft.public.access.tablesdbdesign)