使用Oracle数据库通过MS Access链接表检索的表 [英] Tables retrieved by MS Access Link Tables using Oracle database

问题描述

我有一个Oracle 10g R2数据库，我的ERP事务就在这里。我正在使用MS Access授权我的高级用户访问我使用MS Access''链接表来提供直接访问。


我注意到并非所有模式中的所有表都在即使使用SYSTEM登录，MS Access也会检索数据库。看起来MS Access检索的表的数量有一个上限。我们需要访问te数据库中的所有表。在以前版本的MS Access中不是这种情况。我不能确定哪个MS Access版本。


在我做的连接尝试中，我使用了Microsoft ODBC for Oracle（2.575.1117.00）和Oracle驱动程序（10.02.00.01） Oracle 10g R2客户端。两者都有相同的结果，这就是我上面所描述的。


有没有人遇到过这个问题？

I have an Oracle 10g R2 database where my ERP transactions reside. I''m using MS Access to grant access to my power users where I use MS Access'' Link Tables to provide direct access.

I noticed that not all tables in all schema in the database is retrieved by MS Access even if SYSTEM is used to login. It looks like there''s an upper limit to the number of tables that''s retrieved by MS Access. We need to access all tables in te database. This was not the case in previous versions of MS Access. I cannot be certain which MS Access versions.

In the connection attempts I did, I used Microsoft ODBC for Oracle (2.575.1117.00) and Oracle driver (10.02.00.01) delivered by the Oracle 10g R2 client. Both had the same outcome which is what I described above.

Has anyone encountered this problem before?

推荐答案

我有一个Oracle 10g R2数据库，我的ERP事务就在这里。我正在使用MS Access授权我的高级用户访问我使用MS Access''链接表来提供直接访问。


我注意到并非所有模式中的所有表都在即使使用SYSTEM登录，MS Access也会检索数据库。看起来MS Access检索的表的数量有一个上限。我们需要访问te数据库中的所有表。在以前版本的MS Access中不是这种情况。我不能确定哪个MS Access版本。


在我做的连接尝试中，我使用了Microsoft ODBC for Oracle（2.575.1117.00）和Oracle驱动程序（10.02.00.01） Oracle 10g R2客户端。两者都有相同的结果，这就是我上面所描述的。


以前有人遇到过这个问题吗？

I have an Oracle 10g R2 database where my ERP transactions reside. I''m using MS Access to grant access to my power users where I use MS Access'' Link Tables to provide direct access.

I noticed that not all tables in all schema in the database is retrieved by MS Access even if SYSTEM is used to login. It looks like there''s an upper limit to the number of tables that''s retrieved by MS Access. We need to access all tables in te database. This was not the case in previous versions of MS Access. I cannot be certain which MS Access versions.

In the connection attempts I did, I used Microsoft ODBC for Oracle (2.575.1117.00) and Oracle driver (10.02.00.01) delivered by the Oracle 10g R2 client. Both had the same outcome which is what I described above.

Has anyone encountered this problem before?

这对我来说是新的。您是否使用获取外部数据选项手动链接表？是否所有表格都在选择列表中可见？

This is a new one on me. Are you manually linking the tables using the Get External data option? Are all the tables visible in the selection list?

这是我的新表。您是否使用获取外部数据选项手动链接表？所有表格都在选择列表中可见吗？

This is a new one on me. Are you manually linking the tables using the Get External data option? Are all the tables visible in the selection list?

我使用MS Access''Link Table选项手动链接Oracle中的表。高级用户通常使用MS Access来更新系统配置，而无需发出SQL语句。

当MS Access连接到Oracle时，检索到的表的列表只完成了1/3也许所有的表。以前，在MS Access成功连接到Oracle之后列出了所有表。

I''m manually linking that tables in Oracle using MS Access'' Link Table option. Power users normally use MS Access to update system configuration without the need to issue SQL statements.

When MS Access connects to Oracle, the list of tables retrieved is not completed only 1/3 of all tables perhaps. Previously, all tables were listed after MS Access makes successful connection to Oracle.

我手动使用MS链接Oracle中的表访问''链接表选项。高级用户通常使用MS Access来更新系统配置，而无需发出SQL语句。

当MS Access连接到Oracle时，检索到的表的列表只完成了1/3也许所有的表。以前，在MS Access成功连接到Oracle之后，列出了所有表。

I''m manually linking that tables in Oracle using MS Access'' Link Table option. Power users normally use MS Access to update system configuration without the need to issue SQL statements.

When MS Access connects to Oracle, the list of tables retrieved is not completed only 1/3 of all tables perhaps. Previously, all tables were listed after MS Access makes successful connection to Oracle.

我猜你的问题在于Oracle当时和表的权限。访问不会限制列表，即使它在您尝试添加太多表时崩溃了。比较列表中表格的权限与列表中未显示的权限。查看是否已将任何其他安全权限添加到Oracle，这可能导致此问题。


如果这没有帮助尝试重新创建DSN，看看是否有帮助

I''d guess you''re problem is with Oracle then and the permissions on the tables. Access wouldn''t limit the list even if it fell over when you try to add too many tables. Compare the permissions on the tables in the list against those not appearing in the list. See if any other security permissions have been added to Oracle which might be causing this.

If that doesn''t help try recreating the DSN and see if that helps

这篇关于使用Oracle数据库通过MS Access链接表检索的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！