Desktop

Ask something
Discussion Locked

Access table dates different on two pcs

0 helpful
5 replies

by debbie

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Access 2000 table on a server. Two different computers are using a combo box on an Access form to select dates from that table. One pc works fine... the 2nd pc the combo box has changed dates... the dates are right except that the year is2020. When the reports are run the incorrect dates are reflected on reports run by the 2nd pc. Has anyone had this happen? What could be the problem?
Thanks.
Debbie

5 replies

by xiaxiong

My first step would be to check the system date on the 2nd PC...

If that isn't the problem I would have to know more about the table.

by debbie

System date is fine. I use the table to look up which dates are in which pay period. Has four field, id(auto nbr), week nbr, date, payperiod nbr. The combo box pulls payperiod (group by), Start date (min date), and End date (max date). No only was the combo box wrong, but the file that was run off the combo box had the wrong dates.

Thanks for any help you can provide... and thanks for taking the time you've already invested.

Debbie

by macros

I'd try another PC and assess which computer is creating the error.
If the error isn't consistant ie you don't get two matching each other for dates then it's most likely a software bug. See if there is a patch. Even if two do match it could still be a software error. Check for a patch anyway.
Just a guess also, but I'd consider a BIOS upgrade, though I think it more likely a CMOS error on one or the other computer. Perhaps you could check at the motherboard manufacturers site for a known fault.

by debbie

Thanks I will pass on the info. I believe it's a problem with the one pc.... the bios, the o/s.... it needs a good working over. Thanks.

This discussion is closed to new replies.