Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Tables in Access XP with Memo fields display #Name? for fields

Status
Not open for further replies.

kramerica

Technical User
Jun 19, 2001
74
US
We have an ODBC Datasource setup.

We have linked multiple tables to an Oracle back end. It would appear that all tables that have a memo field, when linked in Access xp display '#NAME?' for all fields in the table!!!!!!

We have the latest patch from Microsoft on this..
WindowsXP-KB829558-x86-ENU.exe (Service Pack 8) Unfortunately when applied and we look at the tables the ones with the memo fields display all the fields as '#Name?'.

Note: some tables have 60 records other tables have thousands of records.. it does not appear to be related to table size.
Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top