January 31, 2007 at 11:21 am
Warning: Being a SQL DBA, I have not touched Access 97 since college (intro course).
I have a user who is trying to connect a linked table to SQL Server. The user is a datareader on the target DB. In SQL Query Analyzer the user can see all the tables in the target DB.
When the user attempts to create a linked table in Access 2003 (11.6355.6568) through an ODBC source setup to use the SQL Server ODBC driver (2000.85.1117.00), they only see the first 1000 or so tables in the list.
The user can connect to a different SQL Server server and return all the tables, 12K+ from that target DB with no problems.
This has been attempted on several different clients all with the same result.
Thank you for any help.
February 1, 2007 at 5:11 am
What servicepack does the Access97 have, SP2?
February 1, 2007 at 7:01 am
I am working with Access 2003, not 97.
Sorry if there was any confusion.
February 13, 2007 at 7:47 am
Does anybody have any ideas? This has me stumped.
February 13, 2007 at 9:09 am
On your Access DB, click Tools/Options/Edit-Find
Increase the value shown in the box that reads
"Don't display lists where more...."
February 13, 2007 at 12:47 pm
Chuck, Thanks for the response.
Unfortunately that was almost the answer. I am trying to query a Peoplesoft database on SQL Server with over 60k tables. The problem as far as I can tell is that Access has a 32k table limitation.
I tested this by creating a user, granting permissions to one table alphabetically low in the database, and reattempting my Access Table link.
Sure enough I only saw the one table and some guest tables.
Thank you for any help you may not have supplied the answer but you pointed my nose in the right direction.
Erik
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply