Nancy,

I've got a couple of DBC utilities that just use a SELECT to get that kind of info:

select ObjectName ;
   from (lcDBC) ;
   into array gaTables ;
   where ObjectType = "Table" and ! deleted()

for i = 1 to _tally
   gaTables[i] = alltrim( gaTables[i] )
endfor

select ObjectName ;
   from (lcDBC) ;
   into array gaViews ;
   where ObjectType = "View" and ! deleted()

for i = 1 to _tally
   gaViews[i] = alltrim( gaViews[i] )
endfor

>We are already using 'set database to' before we call the code, any other ideas?

Is it possible that you've got a corrupt DBC or DCX file for the third database? Does the third one work is you run your code against it first?