M
mewins
I have 2 coworkers who enter data that, for no apparent reason, doesn't save.
Here is what I have:
-I have a master back and 3 separate front ends. Everything is linked
through the ClientID in the tblMainClientInfo, and is showing as correctly
linked on all computers
-When 2 coworkers enter in case notes in subfrmCaseNts, they claim it looks
fine, but when they navigate back to that client later, the case note has
disappeared (and checking tblCaseNts where it should be saved shows no such
record existing).
-The subform is linked to the main form via ClientID
-This problem existed when multiple people were in the same front end at the
same time, so I gave the coworkers their own front ends with a brand new,
uncorrupted subfrmCaseNts
-The main form already has a me.dirty command upon closing
The problem continues even after I installed the individualized front ends.
This only seems to happen to 2 coworkers and I can't discern a pattern of
time of day or particular client. tblCaseNts gets entries from other people
and they don't seem to have problems with it (entering it in to the original
shared front end the 2 coworkers were using, or one of the other 2 front
ends). Entire months of case notes by these two coworkers are disappearing
and I'm not sure what else to look for. I'm not sure if it is their
particular machines or if it's something systemic. Everything is linked
correctly as far as I can tell. All entries in tblCaseNts are date stamped
upon creation and other notes will be saved just fine while on the same day
the 2 coworkers will have issues. Is there a way I can prevent case notes
from being deleted from the table? Is there another link between the subform
and the table I need to check? Any help is greatly appreciated.
Here is what I have:
-I have a master back and 3 separate front ends. Everything is linked
through the ClientID in the tblMainClientInfo, and is showing as correctly
linked on all computers
-When 2 coworkers enter in case notes in subfrmCaseNts, they claim it looks
fine, but when they navigate back to that client later, the case note has
disappeared (and checking tblCaseNts where it should be saved shows no such
record existing).
-The subform is linked to the main form via ClientID
-This problem existed when multiple people were in the same front end at the
same time, so I gave the coworkers their own front ends with a brand new,
uncorrupted subfrmCaseNts
-The main form already has a me.dirty command upon closing
The problem continues even after I installed the individualized front ends.
This only seems to happen to 2 coworkers and I can't discern a pattern of
time of day or particular client. tblCaseNts gets entries from other people
and they don't seem to have problems with it (entering it in to the original
shared front end the 2 coworkers were using, or one of the other 2 front
ends). Entire months of case notes by these two coworkers are disappearing
and I'm not sure what else to look for. I'm not sure if it is their
particular machines or if it's something systemic. Everything is linked
correctly as far as I can tell. All entries in tblCaseNts are date stamped
upon creation and other notes will be saved just fine while on the same day
the 2 coworkers will have issues. Is there a way I can prevent case notes
from being deleted from the table? Is there another link between the subform
and the table I need to check? Any help is greatly appreciated.