Linking FOXPRO table to Access 2000

[nanic]

I am using Access 2000 and linking to 20 foxpro tables (foxpro 3.0b). These are corporate tables and properties cannot be modified. My problem is as follows:

any foxpro tables that have blank date/time field get converted to december 30, 1899 in Access 2000. Never had this problem with Access 97. Is there a way of fixing this?

 

[spayne]

Nanic,

If your date/time field is empty, try setting your field equal to NULL rather than an empty character value.

Good luck,
Steve

 

[nanic]

Thanks Steve for your reply. Unfortunately I cannot change the parameters of the FOXPRO files since I don't have the rights. All I can do is link to them.