I got this error running a query. This query has been running fine for several weeks and I have made no changes to it. I copied the SQL to another new query and the new query worked. I then deleted the original query and renamed the new query to the old name and it now works. Any idea what could have caused this? I did run a compact and repair recently and I may have previously had to have my session cancelled when some logic was looping. I'm just concerned my database may be damaged, even though now it seems to be functioning fine. Access 2003.
- Edited by AllTheGoodNamesWereTaken Thursday, June 07, 2012 6:06 PM
Welcome to the MSDN forum!
Please check this link:
"The error is because a column ID is not valid in a linked table. Try deleting and recreating the links, or alternately making sure both front and backends are compacted.
You can probably avoid compacting by deleting and recreating table links in many cases; this will clear cached info, obviously (since it is cached in the link)."
Hope it helps.
This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
MSDN Community Support | Feedback to us