I connect the tcibd001 table to my Access with a ODBC ( create with Oracle driver) but on each field of each record i receive the message !ERROR. Using the same ODBC with Excel instead work good!!!
Could someone help ?

Thanks Ba

Because if you can see the table then your ODBC driver is doing something at least.
If not, then check if your ODBC driver complies with your Oracle version. Given that it works in Excel though I would think it does.

Alternatively, try linking the table programtically in a new module:


Option Compare Database
Option Explicit

Function AttachTable() As Variant
On Error GoTo AttachTable_Err

Dim db As Database
Dim tdef As TableDef
Dim strConnect As String

Set db = CurrentDb()
strConnect = "ODBC;DSN=oraweb;DBQ=qit-uq-cbiw_oraweb;DATABASE="
' NOTE: DSN is your ODBC Data Source Name; DBQ is your TNSNAMES.ORA entry name

Set tdef = db.CreateTableDef("MY_ACCESS_TABLENAME")
' tdef.Attributes DB_ATTACHEDODBC
tdef.Connect = strConnect
tdef.SourceTableName = "MY_ORACLE_TABLENAME"
db.TableDefs.Append tdef

AttachTable_Exit:
Exit Function

AttachTable_Err:
MsgBox "Error: " & Str(Err) & " - " & Error$ & " occured in global module."
Resume AttachTable_Exit

End Function


Better yet, don't use Access to mess with your Baan data ;)

Something to do with the date format bug in the Oracle driver or Access.
On our system I get the same error for tccom001 table. GTM on table shows blank values for date fields.

Check this thread

http://www.baanboard.com/baanboard/showthread.php?t=7820

Here is the doc, explains the common errors with odbc