I am trying to link oracle table in MS Access. Under ODBC, I have defined the system DSN.
Through access, when I try to link to a table (File, Get External Data, Link Tables) after supplying user name, password and server (username/password@server ), it shows only one table (_ALL_INSTANTIA TION_DDL) and when I double click the table, the MS access generated error "There are several Tables with that name. Please specify owner in the format 'owner.table'.
Now I am stuck here. I don't know why it is not showing the complete list of table.
Regards,
Through access, when I try to link to a table (File, Get External Data, Link Tables) after supplying user name, password and server (username/password@server ), it shows only one table (_ALL_INSTANTIA TION_DDL) and when I double click the table, the MS access generated error "There are several Tables with that name. Please specify owner in the format 'owner.table'.
Now I am stuck here. I don't know why it is not showing the complete list of table.
Regards,