The missing piece - Table/View/Synonym not found (7519)

Hi All.

Sorry for asking such a basic question, but I'm running out of time.

I have some financial software that has bounced itself around servers for many years. From the looks of it, the last time data was entered was around 2006. All employees that knew anything about it (eg logon credentials) are long gone. However, I need to extract data from it before disposing of the server.

The database is Progress 9.1E

I can successfully connect and run ABL queries and use the progress tools to view data dictionaries etc. I have followed the knowledge base articles and created a new user, set them to be a DBA, and logged in with sql explorer as that user.

The table I want to use (as a test) is called ca-detail. I am logged in with the tmladmin2 account

I have the following output (formatted) from sql explorer.

select * from sysprogress.systables where TBL='ca-detail';

        ID TBL                              CREATOR                          OWNER                            TBLTYPE

       107 ca-detail                        PUB                              PUB                              T     

      SEGID HAS_PCNSTRS HAS_FCNSTRS HAS_CCNSTRS HAS_UCNSTRS TBL_STATUS       RSSID

          0 N           N           N           N           Y                    5

select * from sysprogress.sysdbauth

GRANTEE                          DBA_ACC RES_ACC
-------------------------------- ------- -------
Administrator                    y       y       
SYSPROGRESS                      y       y       
tmladmin                         y               
tmladmin2                        y       y      

select * from pub.ca-detail;

=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)

Can some one help me fix the missing bit?

Thank you.