My query broke after 6 years.

  • Thread starter Thread starter Todd Heiks
  • Start date Start date
T

Todd Heiks

MS Access 97, MS SQL 7

Here is a weird one. This query has been working forever and last week it
freaked out.

I am updating a local db with records from a MS SQL Server. I only want
records I don't already have.

The query looks like this:

SELECT dbo_Notes.ID, dbo_Notes.SomeData
FROM dbo_Notes LEFT JOIN Notes ON dbo_Notes.ID = Notes.ID
WHERE Notes.ID Is Null ;

Worked great since '98, last week it started returning all rows from
dbo_Notes even when they are present in the local file.

I repaired the local *.mdb. I recreated the local *.mdb. I ran a checkdb
over the SQL data with no errors.

Any Ideas?
Thanx
 
Todd

That seems like a fairly straightforward query. Have you created a new
(second) query to do the exact same thing and tested it? For your original
query to go berserk like that, maybe there's some subtle internal
corruption.

Have you used the SQL Server feature to inspect what query it thought it
got?
 
Back
Top