Home » RDBMS Server » Networking and Gateways » ODBC MS Access-Not showing tables
ODBC MS Access-Not showing tables [message #67161] Wed, 07 January 2004 08:29 Go to next message
Jeff
Messages: 63
Registered: July 1999
Member
Hello, One of our users of MS Access uses ODBC to connect to Oracle (link table). She is able to connect to some instances of the database but other instances just show one table. Using SQL Plus she is able to access many more tables. Putting a trace on the ODBC connection shows all of the tables being accessed but by the time the MS Access list box appears only one table shows up. Since she is able to access other instances of Oracle with the same security roles, I assume it may have to do with the Oracle server side. Any clues? Thank you.

Report message to a moderator

Re: ODBC MS Access-Not showing tables [message #67209 is a reply to message #67161] Mon, 09 February 2004 23:24 Go to previous message
Stuart
Messages: 7
Registered: September 2000
Junior Member
Hi Jeff,

It sounds like i am experiencing the same problem in Access building the list of Oracle tables. Have you been able to find a solution.

thanks in advance,
Stuart

Report message to a moderator

Previous Topic: weird problem about the listener
Next Topic: Intermittent 0313 error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 19:38:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.