locked
Ms Access 2010 DB Issue with the year in the date RRS feed

  • Question

  • I have MS Access 2010 with an issue where the year is changing to something else other than the year that was typed and saved. The same DB will show and save the correct year, and will be different for another user. So the date format is this and should stay this:  MM/DD/YYYY (like 10/26/2011). It would change to 10/26/1126  - it seems like there is a pattern where it is moving the last 2 digits of the year to the front and placing the day at the last 2 digits of the year.

     

     

    Wednesday, October 26, 2011 9:42 PM

Answers

  • This sounds like you need to do a compact and repair. If that doesn't work then try decompile then compile.
    Chris Ward
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Thursday, October 27, 2011 1:47 PM
  • This is usually a because you used the input mask when creating the table and put a 99 in the first 2 or last 2 digits of the year part of the date. Instead use format short date in your table and the same in your form.
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Thursday, October 27, 2011 6:53 PM
  • Check and compare the user PC and yours in the OS Regional Settings. Are they the same Date Format?
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Friday, October 28, 2011 1:06 AM

All replies

  • This sounds like you need to do a compact and repair. If that doesn't work then try decompile then compile.
    Chris Ward
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Thursday, October 27, 2011 1:47 PM
  • This is usually a because you used the input mask when creating the table and put a 99 in the first 2 or last 2 digits of the year part of the date. Instead use format short date in your table and the same in your form.
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Thursday, October 27, 2011 6:53 PM
  • Check and compare the user PC and yours in the OS Regional Settings. Are they the same Date Format?
    • Marked as answer by Bruce Song Friday, November 4, 2011 8:25 AM
    Friday, October 28, 2011 1:06 AM