Y2K dates imported from dbf file are 1900 dates

[Larft]

I have an access '97 DB that imports data from DBF files via linked tables, I then create Access tables by a make table query so the tables are recreated each time an update is performed (the originating database is still in DBF format). I have a problem either with the import seeing the 2000, 2001, 2002 dates as 1900 etc. or the data are recorded as 1900 etc. Any suggestions on how to correct this and get them into this millennium?

 

[Isadore]

1900 suggests you have a problem in the expression of the date in the dbf file; its a default value. So, I don't think its related to 2000+. Check your dbf file