Problem in linking oracle table

[dhina]

Hi all,
When i try to link some 8 tables from an oracle database,
7 tables get linked and one not.
The oracel table name is stsdb_sys.usr_t
The error i got is,
-----------------------
The database engine can't find stsdb_sys_usr_t. Make sure it is a valid parameter or alias name, that it doesn't include invalid characters or punctuation, and that the name isn't too long.
------------------------


Any ideas what the problem will be?

thanks folks.

Dhina

 

[Newman]

You'll have to change the table's name in your Oracle DB because there is a dot in it and Access won't accept it:

stsdb_sys.usr_t
---------^

In access it means:
Table: stsdb_sys
Field: usr_t

Instead of:
Table: stsdb_sys.usr_t

One thing that could be done to prevent renaming everything in the Oracle db, is creating a copy of that table (in Oracle) and rename the copy so it has no dot in it. But you'll have to make sure that any modification in the original table is also made in the new one.