Start Free Trial
SQL Table Index (on Azure) Preventing MS Access ODBC Link
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:
s.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.
8/22/2022 - Mon
Just delete the index and then rebuild it.
Actually there were 3 indexes and my data is in "deadlock". I can add new records but can't edit them, not even the new ones.
I deleted all 3 indexes and still my data is in deadlock. It's just affecting 1 table. I can't even open that table. I can only see data in that table by doing a query.
can you delete the entire database and reload it from Access?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent