Re: SQL Losing Data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Neil Ginsberg (nrg_at_nrgconsult.com)
Date: 01/22/05 

Date: Sat, 22 Jan 2005 14:11:55 GMT

"Trevor Best" <nospam@besty.org.uk> wrote in message
news:41f23b80$0$13392$fa0fcedb@news.zen.co.uk...
> Neil Ginsberg wrote:
>> For those who have been following this, here's a follow-up and
>> (hopefully) the conclusion of this issue.
>>
>> I switched the mechanism for creating a new record from going to the new
>> record in the bound form to creating one in the table, requerying the
>> form, and then going to that newly created record. The problem is gone.
>>
>> So, apparently, there was some glitch with creating a new record through
>> the form, then immediately going to a subform and then out of it again to
>> the newly-created record that Access or the ODBC driver couldn't handle.
>> As noted, data that was entered after coming out of the subform was lost
>> about 10% of the time, even though the users did an explicit save with
>> the Save Record menu command and/or Shift+Enter.
>>
>> In any case, as noted, creating the new record in code and then going
>> there cleared up the problem. So, whatever the reason was, I'll just be
>> doing that from now one.
>>
>> Thanks to everyone for their input!
>
> That's Wierd City Arizona,

:-)

glad you've got a workaround but I bet the
> root cause will niggle away at the back of your mind for some time to
> come.

I dunno. I've already wracked my brains so much on this, that I doubt I'll
be able to do more. I'll probably I'll just chalk it up to inadequacies in
the system and move on.

Thanks again for your input!

Neil

>
> --
> This sig left intentionally blank

Relevant Pages

  • Re: SQL Losing Data
    ... Neil Ginsberg wrote: ... > For those who have been following this, here's a follow-up and ... > newly-created record that Access or the ODBC driver couldn't handle. ... data that was entered after coming out of the subform was lost about ...
    (microsoft.public.sqlserver.odbc)
  • Re: Returning Focus to Main Form
    ... You mean noting that the solution to the problem causes problems in other ... > Neil Ginsberg wrote: ... >> AfterUpdates, including those done with the mouse. ... >> selects an item with the mouse and then clicks in the subform, ...
    (microsoft.public.access.formscoding)
  • Re: SQL Losing Data
    ... Neil Ginsberg wrote: ... This just happened twice. ... > the information doesn't get lost. ... > So it seems the data is getting lost even before the user exits the record ...
    (microsoft.public.sqlserver.odbc)