Cannot see data in certain records

  • Thread starter Thread starter ryanpurdy3
  • Start date Start date
R

ryanpurdy3

I have a database that is storing operational data on a daily basis.
It is a split db with the backend residing on a server and the front
end on various desktops.

Users pick from a list of dates to see the data for that day. One of
my users can't see any data past April 4. Any date he picks after
that the record is blank. I have checked on my FE and 2 others and we
can see data for those days.

Has anyone encountered a problem like this before?
 
Two thoughts:

Do some of the records have times in them? If he is looking for dates equal
to April 8, 2008 and there's records with April 8, 2008 11:00 AM, those
records won't show. Also he might not see the time portion depending on the
formatting in the table, query, or form.

Next would be somethig with regional settings. If set to something not USA,
there's a good chance that 4/5/2008 is being interpeted as 4 May 2008. If you
don't have data that far out, it won't return records.
 
Check to make sure he is linked to the correct backend. He might be looking
at a copy made 4 days ago rather than the live file.
 
Thanks for all of your responses. He is definitely using the right
backend as the drop down has all the dates from the backend table. It
is also a date only, no time involved. If I use his front end on my pc
there isn't a problem so there may be an issue with his regional
settings? That will be my next step. Thanks again.
 
Back
Top