Is it possible to save year 1 to 99 as date-value in Access database?

Access automatically converts any value under 100. ie: 0099 converts to 1999 and 0010 to 2010 and 0001 to 2001.

Is there any w开发者_开发知识库ay around this problem or is it not possible to save dates in Access so far away?

Access won't let you store dates earlier than 1/1/100 AD.

Of course, you could always just store an integer for the year and do your own date handling.