link to oracle table list shown is incomplete


D

dl

I am trying to Link access to oracle. This what I have done.
1. I created an odbc source.
2, create a new database
3. I click on get external data , more and then odbc database
4. choose link to datasouce by creating a linked table
5 It then opens a list of oracle table to choose from

The problem is the table list is long but incomplete. The list stops
with the table begining with name_
We have many tables after that and they are not shown in the list like
name_a, name_b, and all the way up to table with names starting with
X.

How do I get the complete list or just get the tables I want which in
this case start with su_

thanks
 
Ad

Advertisements

J

Jeff Boyce

I have run into a similar apparent lack of table names with SQL-Server. In
the end, the reason I couldn't see the tables was because the DBAs had not
given me permission to see them.

Are you quite certain the DBAs have given you/your PC/your ODBC permissions?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top