需要帮助在MS Access中链接Oracle表 [英] Need help linking oracle tables in MS Access

问题描述

我在使用MS Access连接到Oracle数据库时遇到一些问题.

I am having some issues connection to an oracle DB using MS Access.

如果我使用SQL Developer连接到Oracle DB，则几乎可以看到数据库中的每个表和视图，但是当我使用MS Access连接时，只会得到一些选定的视图.

If I use SQL Developer to connect to the Oracle DB I see pretty much every table and view in the DB however when I connect using MS Access I only get a selected few.

我很难理解，这是因为用户在我需要的表上没有选择"特权，所以我请求了该特权，在等待了一段时间之后，我终于获得了特权，但是我仍然无法在Access工具上看到这些表.

I tough it was because the user didn't have Select privileges on the tables I need so I requested the privilege and after a moth of waiting I finally got it but I still cant see the tables on the Access tool.

这是我在SQL Developer vs MS访问中看到的.我需要SFMFG.PWUI_CHAR_DEF_EXT才能在访问表管理器上显示.对于解决这个谜团的任何帮助，我们深表感谢.

This is what I see on SQL Developer vs MS access. I need SFMFG.PWUI_CHAR_DEF_EXT to show on access table manager. Any help to solve this mystery is greatly appreciated.

推荐答案

使用Access 2010，如果我选择External Data ==> ODBC Database ==>通过创建链接表链接到数据源，则会出现Windows对话框所有可用的数据源.当我登录到想要的表时，会看到我有权选择的所有表的名称.

Using Access 2010, if I select External Data ==> ODBC Database ==> Link to the datasource by creating a linked table, I get a windows dialogue of all the available datasources. When I log in to the one I want, I see the names of all the tables I am authorized to select from.

链接表管理器仅显示具有现有链接的表.

The Linked Table Manager only shows the tables for which there are existing links.

这篇关于需要帮助在MS Access中链接Oracle表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！