I've successfully migrated an Access 97 database to Oracle 9i, but I'm having trouble connecting to certain tables from MS Access. The common feature of these tables is that they have notes fields of type Memo
These fields have been correctly migrated to CLOB in Oracle, but when I look at them in the Design view of Access, they show as being of type Text
I've attempted to create another Access linked table to one of these Oracle tables, but the notes field still shows as type Text
When these linked tables are opened, I get one of two errors:
"Reserved Error (-7711), there is no message for this error" followed by "SRS Belfast MI can't open this table in Datasheet view"
"ODBC - call failed" followed by "[Microsoft][ODBC Driver Manager] Function sequence error (#0)" followed by the Datasheet view opening will all the fields displaying #Name? as values