General discussion

Locked

Access table dates different on two pcs

By debbie ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access table dates different on two pcs

by XiaXiong In reply to Access table dates differ ...

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.

Collapse -

Access table dates different on two pcs

by debbie In reply to Access table dates differ ...

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

Collapse -

Access table dates different on two pcs

by Macros In reply to Access table dates differ ...

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.

Collapse -

Access table dates different on two pcs

by debbie In reply to Access table dates differ ...

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.

Collapse -

Access table dates different on two pcs

by debbie In reply to Access table dates differ ...

This question was closed by the author

Back to Desktop Forum
5 total posts (Page 1 of 1)  

Related Forums