asked on Need help linking Access 0365 to an MS SQL Server 2017 table with 34 indexes
I"m trying to link an Access o365 application to a BE table which had 34 indexes. I know Access itself has a limit of 32 indexes per table, but I thought there was a way to get past that with SQL... yes?
THanks
THanks
Microsoft 365Microsoft AccessMicrosoft SQL Server
Last Comment
pcalabria
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Fabrice, I can give that a try if there is no way to have more than 32 indexes in an SQL Server table linked to Access. Is this the case? I thought it was possible???
As @Fabrice already wrote: just link to a view instead. Or, when you don't need to modify data, you can use a PT query.
In my applications I rarely link to tables at all.
As a rule of thumb: views for data sources for forms and controls, stored procedures for reports.
And for your question: Access creates the indices it finds in the backend also for the linked table to support performing client-side data processing. Thus a table must not have more than 32 indices, when you want to link it directly.
In my applications I rarely link to tables at all.
As a rule of thumb: views for data sources for forms and controls, stored procedures for reports.
And for your question: Access creates the indices it finds in the backend also for the linked table to support performing client-side data processing. Thus a table must not have more than 32 indices, when you want to link it directly.
ASKER
Thanks guys!