M mike New member Local time Today, 15:48 Joined Nov 9, 2008 Messages 1 Nov 9, 2008 #1 I use Access 2003 with an ODBC link to SQL Server 2000 and 2005. I have run into a problem linking to a table with more than 10 indexes on it. Is there a way around this? None of the indexes can be removed from the table.
I use Access 2003 with an ODBC link to SQL Server 2000 and 2005. I have run into a problem linking to a table with more than 10 indexes on it. Is there a way around this? None of the indexes can be removed from the table.
SQL_Hell SQL Server DBA Local time Today, 23:48 Joined Dec 4, 2003 Messages 1,359 Nov 10, 2008 #2 What problem are you having? can you post an error message? Does this table have a primary key? Can you post the DDL of your table?
What problem are you having? can you post an error message? Does this table have a primary key? Can you post the DDL of your table?