• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Y2K Issue w/ VB 6 & Access 97

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.
0
dfhaines
Asked:
dfhaines
1 Solution
 
CoatesCommented:
Ive found sometimes that access follows the regional settings of the PC, no matter what formatting is applied to them.
I think they may still be stored as dd/mm/yyyy, put the regional settings may cause them to be displayed otherwise.
Give this a try
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now