Carrying Data Forward - Unintentionally

[Louise54]

We have an Access application that we've been using for years. The back-end
is 2.0 (I know, I will be converting later this month). The front-end is
installed on each user's local drive. After years of use, one user who has an
Access 2003 front-end db started experiencing carryover of data from one
record to the next in a particular form. On reboot the next day, the same
thing happened throughout the day. It was never set up to do this, and in
this case, is more of an annoyance than a help. What could have caused this
to happen?
I did a repair/compact on his database this morning and after a quick test
it appears to be ok for now. Any ideas on how this occurred in case it
happens again?
Thanks in advance for your help!
Louise

 

[Gina Whipp]

Louise,

Just a thought... in the Access 2003 front end turn off Name Auto Correct
Tools - Options - General) it has been known to cause *strange behavior.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Louise54]

Thanks Gina. I'll definitely take a look at that if/when the problem starts
up again today. Appreciate your help!
-Louise

 

[Gina Whipp]

Louise,

I would turn it off regardless, as it REALLY does cause odd behavior in
databases. THEN if the problem never comes up again you know what it was.

You're welcome!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Louise54]

I just checked his workstation and it was already off. It must be turned off
as a default?
Thanks again.
Louise

 

[Gina Whipp]

Nope, it's actually turned on by default. Okay so if that problem comes
back we know where NOT to look!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm