Hoping for any suggestions on this one: We've been linking Oracle tables through ODBC (in Access 2003) for several months now. Just recently, when you bring up the 'Link Tables' window, only a partial list of the Oracle tables appear. It's not the 'available columns' item, or anything like that, but just a partial list of the tables in the Oracle db. It's very strange, like something on the server-side is timing out.
Currenltly I'm using a custom-built form to connect tables by code, but it's been buggy. Any suggestions how to get the full list of tables back? I've tried tweaking the firewall, ports etc. with no luck.