W
Will Feaser
I am using an ODBC datasource to connect Access 2000 to a
SQL Server 2000 database. When the "Link Tables" box
appears, it displays only one table. The database
contains 19087 tables (it is a PeopleSoft database), and I
have dbo rights on the database. Thinking that I was
timing out, I increased the ODBC timeout to 600 seconds,
but that did not help. The "Link Tables" box appears
after about 30 seconds. Any idea why I can not see all of
the tables?
Using an identical ODBC datasource, I can connect to
another database on the same server and see all of the
tables in that database.
The problem is occurring on several of our "developer"
PCs. The PCs are running Windows 2000 or Windows XP.
Conversely, there are several PCs on which this works.
SQL Server 2000 database. When the "Link Tables" box
appears, it displays only one table. The database
contains 19087 tables (it is a PeopleSoft database), and I
have dbo rights on the database. Thinking that I was
timing out, I increased the ODBC timeout to 600 seconds,
but that did not help. The "Link Tables" box appears
after about 30 seconds. Any idea why I can not see all of
the tables?
Using an identical ODBC datasource, I can connect to
another database on the same server and see all of the
tables in that database.
The problem is occurring on several of our "developer"
PCs. The PCs are running Windows 2000 or Windows XP.
Conversely, there are several PCs on which this works.