Have a couple of Access MDB based applications that pull some of their data from SQL2K tables via ODBC. All the sudden we've been noticing failures. When we step through, it looks like intermediate tables being created by join queries are mising some/all data. Nothing has changed in the VBA code, and we made the switch from SQL7 to SQL2K several months ago, but are just now seeing this issue...
When we manually query the individual tables, the data is there, but when we run the join, the destination table is either empty or missing data
Any Thoughts?
Tnx--Dan In Tacoma