469,140 Members | 1,211 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,140 developers. It's quick & easy.

Linking MS SQL tables into MS Access 2003 VBA - too many indexes

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.
Aug 22 '07 #1
0 1062

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by John South | last post: by
14 posts views Thread by diskoduro | last post: by
5 posts views Thread by Christoph Sticksel | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.