I hope someone can help me out here. I currently have an Access 2000 Database created from ODBC Links. I have a Query based on the Table. The problem, one of the Sections of the Table is Date based Information. When I use the standard prompt for date entry [Enter Date], I get an ODBC Failure Error. When I enter a date format as 05/12/2003 the data is correctly received.
I have tried just about everything. I created a separate Table on the local information to pull the date information with no luck. I have even tried the Like Condition.
I am using a DB2 Interface to communicate with the AS400 Mainframe to pull the information into my tables.
If anyone has ANY information on this subject it would be GREATLY Helpful.
Jack
I have tried just about everything. I created a separate Table on the local information to pull the date information with no luck. I have even tried the Like Condition.
I am using a DB2 Interface to communicate with the AS400 Mainframe to pull the information into my tables.
If anyone has ANY information on this subject it would be GREATLY Helpful.
Jack
