network data loss

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an end user who states they are making entries in a form, but the
entries they make are disappearing. This is a simple database (no FE/BE)
with a simple form/sub-form where they type the part number and the sub-form
pulls up all existing entries for that part and they can edit or add a new
entry. Typically only 1 person will be in the database at a time, though
sometimes it could be two.

The database is shared over the network from my work computer, which is
linked to where the end-user is by a slow wireless link, about 5Mbps up/down.
I keep it on my computer because I'm the primary user of the database and
I'm not going to work over a slow-link :)

My question is, is it possible that data can be completely lost over this
slow-link and what she's typing in the form on her computer is not being
updated to the database on mine? Wouldn't she receive some form of error
that Access isn't able to connect? Anything?

I'm assuming it is just the end-user, but I wanted to be positive. What do
you think? Can this slow-link be causing the issue? Or are they just not
properly making entries in the form? Thanks for your help!
 
Justin said:
I have an end user who states they are making entries in a form, but
the entries they make are disappearing. This is a simple database
(no FE/BE) with a simple form/sub-form where they type the part
number and the sub-form pulls up all existing entries for that part
and they can edit or add a new entry. Typically only 1 person will
be in the database at a time, though sometimes it could be two.

The database is shared over the network from my work computer, which
is linked to where the end-user is by a slow wireless link, about
5Mbps up/down. I keep it on my computer because I'm the primary user
of the database and I'm not going to work over a slow-link :)

My question is, is it possible that data can be completely lost over
this slow-link and what she's typing in the form on her computer is
not being updated to the database on mine? Wouldn't she receive some
form of error that Access isn't able to connect? Anything?

I'm assuming it is just the end-user, but I wanted to be positive.
What do you think? Can this slow-link be causing the issue? Or are
they just not properly making entries in the form? Thanks for your
help!
Click to expand...

The chances are very high that the person is incorrect about the data not
being saved or that she is doing something incorrect ot cause it.

About the only known issue that "could" cause this is there has been a
long-standing bug in Access where if you close a form with a custom close
button and the record that was entered was "illegal" (missing a required
field for example) that it would be silently discarded instead of raising an
error.

That scenario is not likely on a form with a subform given the way records
in each form are saved as you move between them.
 
Thanks for the quick response. I don't have a custom close button nor does
the subform even have any required fields. It has to be the
end-user...they're just never goign to believe it. Oh! It has to be the
database, you know? End-users...
 
I have seen applications and users that are not "compatible". The
application/form opens and displays an existing record. The user believes
that typing a new record into the existing record will mistakenly add a new
record and somehow keep the existing record.
 
Back
Top