I use Azure SQL as my Access backend. I tried to relink a table yesterday but it wouldn't link and gave me the following error message:
'Tblsales_salesstore_status.idx' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
Using SSMS I renamed the index by deleting the ".idx" extension and now my table will link but the index stopped working. Now my queries are slow and some won’t work (time out).
I would guess that this is a quick fix for an expert and wouldn't mind paying someone to fix it.