Secret ingredients to quality software

We open source.Loving SSW Rules? Star us on GitHub. Star

© 1990-2025 SSW. All rights reserved.

FEEDBACK / SUGGEST A FEATURE|TERMS AND CONDITIONS|

This website is under CONSTANT CONTINUOUS DEPLOYMENT. Last deployed 13 minutes ago on Dec 19, 2025 at 10:10 UTC (Build # 8-0ed4115)

Powered by Azure and GitHub

SSW Rules
Access Databases
This rule

Do you always have a unique index on a table?

Loading last updated info...

Open in ChatGPT

If Access linked table does not have an index to uniquely identify rows, the whole table will be read-only

Upsizing PRO will check this rule

Categories

Access Databases

Authors

Related rules

Do you have hidden tables or queries (Upsizing problem)?
Do you avoid underscores (preference only)?
Do use spaces in table names?

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.