Re: SQL Losing Data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Sat, 15 Jan 2005 16:34:09 GMT

As noted, I'm just using the bound form's built-in save command. In this
case, the user is selecting Save Record from Access' Records menu. Other
times, the users may move to a new record, causing Access to perform an
automatic save.

The only time where code comes into play is if the user clicks the New
button, which first performs a docmd.runcommand accmdsaverecord before
moving to the new record. But that wasn't the case here; the user just
selected the built-in Save Record command.

Neil

"Trevor Best" <nospam@besty.org.uk> wrote in message
news:41e8f80f$0$4358$fa0fcedb@news.zen.co.uk...
> Neil Ginsberg wrote:
>> For those who have been following this, here's a note I just got from one
>> of the users. If this situation was bizarre before, this just brings it
>> to a new level.
>>
>> "I type in either keynotes [varchar 255] or notes [text]. Save (using
>> Save Record from the Records menu). Then, if I'm working in notes and
>> save, and click into either keynotes or citation [varchar 255], I
>> immediately lost all information in both notes and keynotes. This just
>> happened twice. And I really do make very sure the information is saved,
>> but it disappears anyway. Doesn't ALWAYS happen like this, sometimes I'll
>> click into another area and the information doesn't get lost. But it did
>> just happen twice that way."
>>
>> So it seems the data is getting lost even before the user exits the
>> record (presumably, clicking in one of the other fields just brings up
>> the latest data in the table, which is blank in those fields).
>>
>> So there's some more that goes into the pot of this weirdness.
>
> What method do you use to save the record in code?
>
>
> --
> This sig left intentionally blank

Relevant Pages

  • Re: SQL Losing Data
    ... Neil Ginsberg wrote: ... I'm just using the bound form's built-in save command. ... the user is selecting Save Record from Access' Records menu. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Boot time taking 3.5 minutes at start-up
    ... I used the command line that you cited, ... When I reinstalled TCP/IP, per the instructions, it obviously did not connect me back to the Internet. ... I went through Networking and Dial-Up, selected Local Area Network/Properties, but when I rebooted, I did not have the option of selecting TCP/IP, so I selected Client for Microsoft Networks and installed that. ...
    (microsoft.public.win2000.general)
  • Re: begin/end select in macro
    ... ExtendSelection command. ... selecting text and a key to end selecting text. ... I could ask Word to find a para ...
    (microsoft.public.word.vba.general)
  • Re: Perl on Windows question
    ... I think you just helped me solve my problem, Sinan. ... program that Perl was using in backticks was the Unix-ish "type" ... not the DOS built-in "type" command. ...
    (comp.lang.perl.misc)
  • [PATCH] bootup: Add built-in kernel command line for x86
    ... Add support for a built-in command line for x86 architectures. ... The default behavior is to append the boot loader string ...
    (Linux-Kernel)