By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,213 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,213 IT Pros & Developers. It's quick & easy.

Quirky Record

P: n/a
I have a client using an Access 2002 front end and back end. A certain
record wasn't showing up in several reports. He sent me the back end (I have
the same front on my machine), and I ran the reports using Access 2000, and
the record showed up. I then notified him, he tried again in Access 2002,
and the record still didn't show up. He then edited a field in the record,
saved the record, and opened the reports again, and then the record showed
up.

Anyway idea as to why the record didn't show up on his end until he
re-edited the record, but it showed up on my end right away?

Thanks!

Neil
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Neil, Without knowing more about what type of fields, criteria etc. that you
are basing the report on the only thing that comes to mind that if the
criteria is based on a date/time field and/or a currency field maybe the
regional settings for the 2 computers are set differently. Hope it helps!

--
Reggie

www.smittysinet.com
----------
"Neil Ginsberg" <nr*@nrgconsult.com> wrote in message
news:iM*****************@newsread2.news.pas.earthl ink.net...
I have a client using an Access 2002 front end and back end. A certain
record wasn't showing up in several reports. He sent me the back end (I have the same front on my machine), and I ran the reports using Access 2000, and the record showed up. I then notified him, he tried again in Access 2002,
and the record still didn't show up. He then edited a field in the record,
saved the record, and opened the reports again, and then the record showed
up.

Anyway idea as to why the record didn't show up on his end until he
re-edited the record, but it showed up on my end right away?

Thanks!

Neil

Nov 13 '05 #2

P: n/a
Could be a case of mild corruption that was overwritten when the record was
edited. It's a good idea, if you suspect mild corruption, to compact and
repair, then import each object into a new, clean database, according to
Peter Miller, who is in the data recovery business.

Larry Linson
Microsoft Access MVP

"Neil Ginsberg" <nr*@nrgconsult.com> wrote in message
news:iM*****************@newsread2.news.pas.earthl ink.net...
I have a client using an Access 2002 front end and back end. A certain
record wasn't showing up in several reports. He sent me the back end (I have the same front on my machine), and I ran the reports using Access 2000, and the record showed up. I then notified him, he tried again in Access 2002,
and the record still didn't show up. He then edited a field in the record,
saved the record, and opened the reports again, and then the record showed
up.

Anyway idea as to why the record didn't show up on his end until he
re-edited the record, but it showed up on my end right away?

Thanks!

Neil

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.