Forum Discussion
Troubleshooting Queries in Access
Hi All,
I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected.
As per the set-up process,
1. Have deleted old tables (with previous data), and imported new data for these tables from a different Access database
2. Then I am doing a compact and repair.
3. Then I am running query that is expected to populate the table, I see no records are added to the table
Could this be a file reference issue **or** lack of data **or** missing tables /steps **or** a connection within Access. Appreciate step by step process to diagnose the issue
1 Reply
We don't have enough information to know what the problem could be.
- Why are you deleting old tables at all? Why are you then importing "new data for these tables"? Does that mean you are actually re-creating those same tables with new data? Why not delete the data from those tables and simply reimport new data? In fact, deleting data is probably not something we'd normally expect to see anyway, so please elaborate on the business purpose being supported.
- SHOW us the query that is expected to populate the table. What table would that be, by the way? Is it one of the ones being deleted and re-created? Or a different table? What data is being used for this repopulation?
We need to see the SQL from this query, not a screenshot of the query design view.
Once we have a better picture of what's going on, we can offer useful suggestions.
- Why are you deleting old tables at all? Why are you then importing "new data for these tables"? Does that mean you are actually re-creating those same tables with new data? Why not delete the data from those tables and simply reimport new data? In fact, deleting data is probably not something we'd normally expect to see anyway, so please elaborate on the business purpose being supported.
