Error message

[RH]

I renamed my tables in a Database that I'm revamping. With one of my tables
I keep getting the error message 'the table or query name you entered in
either the property sheet or macro is mispelled or refers to a table or query
that doesn't exist'. I've been through all my tables, queries, forms, etc.
and can't find the reference to the table that I've renamed. Is this some
glitch in Access?

 

[Allen Browne]

Suggestions:

1. Make sure Name AutoCorrect is off, and then compact/repair your database.
Details in:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

2. If you're still stuck after that, and this happens in the table, you
could look in these properties of the table:
- SubdatasheetName
- Filter property
- OrderBy property
- Validation Rule

3. If the table shows combo boxes in some fields, open the table in design
view, select the Lookup tab for those fields, and look there (e.g. in the
RowSource.)

There are other possibilities if the problem occurs in a query, form, or
report.

 

[RH]

Thanks, that helped with one of my tables.

Suggestions:

1. Make sure Name AutoCorrect is off, and then compact/repair your database.
Details in:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

2. If you're still stuck after that, and this happens in the table, you
could look in these properties of the table:
- SubdatasheetName
- Filter property
- OrderBy property
- Validation Rule

3. If the table shows combo boxes in some fields, open the table in design
view, select the Lookup tab for those fields, and look there (e.g. in the
RowSource.)

There are other possibilities if the problem occurs in a query, form, or
report.