Hi all,

Client OS: Windows2000, Application: MS ACCESS-2000
Database Oracle8.1.7 on OS IBM-AIX4.3

I'm facing the following problem:
Trying to open an BaaN-table tc.com.001.company with MS-Access2000 the only thing i get are the following errors for ALL fields and records:
"Reserved error (-7776) There is no message for this error".

Taking a look into the table with Oracle DBA Studio => Table editor: I see a date into the field 'edte' of: '01-01-10000' (Yes the year Ten Thousand).
Taking a look with the tccom0101m000 session the date has being displayed as blank.
Taking a look with SQLPLUS i see a date: '01-01-9999'.

Has anybody faced the same problem with MS-ACCESS-2000 and if so, solved the problem?

GN

I have the nearly the same problem. The problem is not related tot MSAccess only. Oracle does not allow empty fields in the database. So all not empty date fields are filled with 01-01-10000. Round the year to 4 digits you get 9999. The main problem is that you cannot read the tablefield. Possible solutions:
- leave the datefield out your query
- change all the 01-01-10000 fields to 01-01-9999
- make the query in Baan easy SQL and output to txt-file, then import in MSAccess.

Do you already have another solution??

EJV

Follow this link:

http://www.baanboard.com/baanboard/showthread.php?s=&threadid=5852&highlight=oradate