indexing - Unable to import/link table from SQL Server into access. Too many indexes error -

indexing - Unable to import/link table from SQL Server into access. Too many indexes error -

i trying import table sql access getting many indexes in table error. table in sql indexed several tables , unfortunately don't have rights modify or alter table anyway. have read access in db. trying import/link table unable due many indexes error beingness thrown.

is possible import/link info , not indexes? know access has limit of 32 indexes. have cleared auto indexes in options too, still error.

is there solution how can import/link table in access?

thanks in advance

i did digging on how avoid problem. problem can't straight link sql database if table has lot of indexes , access throw error "too many indexes on table trying import".

one way beat putting "pass-through query". lot of people suggested vba code. not coder , not work effectively. however, access gives capability build out vba , solution found in microsoft website.

the steps follows: might have work around 2010 due different naming convention when compared 2007.

on create tab, click query design in other group. click close in show table dialog box without adding tables or queries. save query. open query in design mode on design tab, click pass-through in query type workgroup. click property sheet in show/hide workgroup display property sheet query. in query property sheet, place mouse pointer in odbc connect str property, , then, click build (...) button.

with odbc connect str property, specify info database want connect. can type connection information, or click build, , come in info server connecting.

when prompted save password in connection string, click yes if want password , logon name stored in connection string information. if query not type returns records, set returnsrecords property no. in sql pass-through query window, type pass-through query. example, next pass-through query uses microsoft sql server top operator in select statement homecoming first 25 orders in orders table sample northwind database: select top 25 orderid orders

to run query, click run in results grouping on design tab. sql pass-through query returns records, click datasheet view on status bar. if necessary, microsoft access prompts info server database.

this worked me. if 1 having same problem can utilize these steps.

indexing ms-access-2010 importerror