I have created a VB 6.0 app using the Access 8.0 Object Library to handle data transactions with an Access 97 database. One of the transactions involves the TransferDatabase method, where I import a dBaseIV file into the Access 97 database. In the dBaseIV file, the date fields are stored with the century indicator in the form, mm/dd/yyyy. However, after I execute the TransferDatabase method, the dates are displayed in the new Access 97 table as mm/dd/yy.
Question 1: Are the dates merely displayed as mm/dd/yy but stored as mm/dd/yyyy?
Question 2: Does Access 97 use windowing to determine the century indicator? (i.e., if I append these records to another table where the format of the date fields is mm/dd/yyyy, will Access window to determine which century the year is in?)
Question 3: How can I transfer the dBaseIV file so that the dates are initially stored as mm/dd/yyyy?
I appreciate your time and attention to this matter.