If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error message
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? |
#2
|
|||
|
|||
Error message
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "RH" wrote in message ... 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? |
#3
|
|||
|
|||
Error message
Thanks, that helped with one of my tables.
"Allen Browne" wrote: 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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "RH" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|