Problem w/Access Automatically Saving Records

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi All,

I've got an Access 2000 database running on Windows 2000 client & server.
From time to time, when the user of the database is entering a new record,
the record is written ('disappears', as the user tells me). The process is
as follows:

1) The user keys in the record
2) The user double checks the data, is interrupted, etc., allowing the data
to sit in the form from a few seconds to a few minutes
3) During checking, interruption, etc., the record is written with no input
from the user
4) The user can find that the record was written using the search form

Here's what's going on with the form:

1) All form navigation is turned off. I.e., the user can only move away
from the form by clicking buttons that explicitly save, cancel, or duplicate
the record, or by closing Access
2) The code behind the form is fairly simple. There is code that hooks the
mouse wheel, clears the clipboard, and validates data, but other than that
the form is pretty straightforward

We suspect that there is something going on with either the server or
network connectivity, but have yet to nail anything specific down. The user
thinks this problem began coming up about 2 weeks ago (but is unsure) and it
turns out that our network admin performed some maintenance on the server at
about that time and that's the last time it was rebooted.

Other than the obvious of looking at the network & server, if anyone has any
suggestions on things to check, your help is appreciated.

Thanks & Ciao,

Tony
 
Sounds like a DEU error (Defective End User) or DAD error (Defective
Application Development).

I'm only being partially facetious. I would have to see it with my own eyes
before I would believe that Access is spontaneously saving a record --
network problems or not. Most likely the user does something without
realizing it and then claims to have done nothing. By their lights, they
have, but that's not the reality.

One thing to check is the "Cycle" property for the form. If you don't want
it to advance to the next record (in this case, probably the New Record),
set it to "Current Record". If it is set to "All Records" it can go to the
next record by hitting Enter on the last control.
 
Roger,

Thanks for the reply. Cycling is set to the current record and I suspect
that it's a DEU error, but wanted to put the feelers out to see if anyone
more experienced than myself had any ideas.

I'll keep an eye on things and if I get it figured out, will post back here.

Thanks,

Tony
 
Well, I don't guarantee it isn't a real problem, but any conversation with a
user that start with, "I didn't do anything it just..." always makes me
suspect user error first.
 
Yep. I have a user who always opened more than 4 Citrix ICA sessions to run
an Access application on the Citrix Server while only 1 ICA session is
required. Nothing of his doings, he claimed, of course.

The ICA session/Access application is slow to appear as Citrix tries to map
the local printer. I suspected that he was too impatient and double-clicked
the shortcut icon numerous times since when I did it on his PC using his
LogOnID, everything worked correctly.

I advised him to double-click the icon only ONCE and then go out to get a
cup of coffee. Since then I had no problems!
 
Roger & Van,

Thanks for the feedback. I still haven't got this one figured out but have
asked the user to note when this happens and what's occurring within Access
and outside of it, like IE sessions, WMP, etc. Oddly enough, since my
request, the phantom record writing has not popped up. Certainly not a
definitive indication that user error is involved, but I like the peace &
quiet anyway...

As always, thanks for the help & suggestions.

Ciao,

Tony
 
Back
Top