"Invalid Argument" when connecting to Oracle8i via Linked Table Mgr

[Katie]

Hi, I need to trouble-shoot an Access 2002 application (written by
somebody else...) It links to a table in Oracle 8i, however, I cannot
establish the connection. I'm trying Linked Table Manager and am
getting "Invalid Argument" error. The configurations in TNSNAMES.ora
are good, as I tested them with Oracle's Net8 Configuration Assistant.
I can also connect to that Oracle table with Toad, but no luck with
Access. What am I missing?
Thanks for any help, Katie.

 

[Joe Fallon]

Please list the exact steps and where the error occurs.

If you get to the screen where the tables are supposed to appear then try
this:

"The list box that displays the objects that can be linked has a limit of
64,000
characters. In my case, the database contains 19,000 tables and 15,000
views, so I quickly exceeded that limit. I resolved the problem by
creating a role in SQL
Server that has access to a limited set of tables \ views.
I assigned a user id to the role and then used the user id in my DSN."

Maybe your ID is "too powerful" and Access is overwhelmed by the number of
tables you can see.
Create a user and try logging in with that ID.