Errors after table name change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I remaned Customers table to Customers_1 and re-created it from scratch. I
later deleted the Customers_1 table. since then I have created so many forms
and queries without any problem. Today I created a Balance query to calculate
balance on customers. When I try to open the query it first gives me an
error message that "Select [customerID], [customer name] from Customers_1" is
not valid. then the query opens and data in there is correct. No where I
could find this query however when I created a Form from Balance query it
autmatically uses "Customers_1" table for a comboBox in the form. In this
form I manually changed the "Customers_1" to "Customers" and it holds. But
everytime I reopen the DB and click on the Balance query the same error shows
up. Turning auto correct off and on did not help. Nor did the repair and
comapct. Any idea how to get rid of this non-existing error?
 
sounds like Name Autocorrect is a likely culprit in this situation; the
residual effects can be difficult to shake, even after turning the option
off. suggest you create a new blank database and *immediately* turn OFF the
Name Autocorrect option, then compact the db. next, import all objects from
your current database into the new database; if you have VBA code in the
database, make sure you run a compile on your modules. then compact again.

hth
 
Back
Top