Hello,
I have a 3rd party app that uses SQL server to store its data. I am also creating a MS Access 2003 app to access the data. When I import the tables a few of the tables have over the 32 index limit. Is there a way to link the tables without indexes or count the amount of indexes and stop after set amount during the import? I cannot change the indexes in SQL because they are used by 3rd party app so I need a way to access the tables and link them; getting around this problem of 32 index limit. THANK YOU.
I have a 3rd party app that uses SQL server to store its data. I am also creating a MS Access 2003 app to access the data. When I import the tables a few of the tables have over the 32 index limit. Is there a way to link the tables without indexes or count the amount of indexes and stop after set amount during the import? I cannot change the indexes in SQL because they are used by 3rd party app so I need a way to access the tables and link them; getting around this problem of 32 index limit. THANK YOU.