Periodically, Office XP and 2003 seem to loose the join in a query. Now that I have a few more that it happens to, I can see the common denominator is linking of a table to a query. The table can be native access or a linked table.
The query so far, has been executed against a linked table; querries against Access native tables have not yet yielded this problem.
Anyone else run into this? Any ideas on how to get around?
For simple queries, the error message usually retains the join I need to reconnect, but for the more complex, with several joins, sometimes it gets messy and I would rather not have to do it in the first place.
Thanks in advance.
The query so far, has been executed against a linked table; querries against Access native tables have not yet yielded this problem.
Anyone else run into this? Any ideas on how to get around?
For simple queries, the error message usually retains the join I need to reconnect, but for the more complex, with several joins, sometimes it gets messy and I would rather not have to do it in the first place.
Thanks in advance.
