I've been in the process of building my first Access database over the past few weeks. It has been pretty enjoyable so far but I just came across something that worries me.
When I go to make a report or form and click 'add existing fields' my main table shows as ~TMPCLP followed by various numbers. This wasn't the case when I was first making forms but I have since removed the original table and re-imported because data has changed since my first attempts of creating a new database (also I split the database a bit prematurely and ended up making it local again). The table and field names have remained the same throughout. I assumed I could delete the table, import a new one by the same name and all would be well...and it has been so far. I just see this as something that could cause a major headache in the future and want to clean it up now but I don't know how. Any advice?
When I go to make a report or form and click 'add existing fields' my main table shows as ~TMPCLP followed by various numbers. This wasn't the case when I was first making forms but I have since removed the original table and re-imported because data has changed since my first attempts of creating a new database (also I split the database a bit prematurely and ended up making it local again). The table and field names have remained the same throughout. I assumed I could delete the table, import a new one by the same name and all would be well...and it has been so far. I just see this as something that could cause a major headache in the future and want to clean it up now but I don't know how. Any advice?
