Microsoft Jet Database Error

[JC3]

Hi all

I had a fully working database that I decided to clean up by standardising naming formats etc. I have changed the tables names and changed all VBA links etc to the new table names.

This all appears to work fine. The database is still doing exactly what it should be doing. The only problem is whenever a record is updated I get the following error,

"The Microsoft Jet Database Engine cannot find the input table or query, "***". Make sure it exists and that its names is spelled correctly".

Where the missing table is the previously renamed table. All the updates etc work correct to the renamed table but I get this error whenever it is updated. I tried renaming the tables to their original names but then I got the same error for the new names.

Anyone got any ideas or will I have to rebuild the database.

Thanks much,

 

[WindSailor]

I did just this same thing a little while ago...
Just recheck your coding and see if it compiles.
Other than that, maybe creating new tables, importing the data, deleting the original table and rename the newly created table (this one usually applies to databases other than Access).
My most common one on this error is VBA coding on forms built off of queries.