I'm having trouble importing queries into a new Access container in Access 2010. This was always a bit of a problem but in previous versions (2003, 2000, 97), with track name autocorrect off and as long as you import local tables and link to outside tables FIRST, then import queries, this was not a problem. Now I am trying to do the same thing but Access 2010 is aliasing all my column names with "Expr1", "Expr2", "Expr3", etc. in queries that are based on combinations of other queries. Again, this did not present a problem for me in previous versions but I cannot seem to come up with a solution and am not finding anything online.
Actually, what appears to be the problem is that when importing objects into the new container, MSysAccessObjects is not being updated. It should have 1120 rows in it in this db. But it only has 3. Never had that happen before. Cannot seem to get this to work at all.
Submit an article or tip