Records not showing in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all... my IT guys are stumped... and frankly so am I. I have a DB with
four linked tables. I can open my main table in Access 2k [TumorTable] and
see that all of my many many precious records are there. I can look in using
the Enterprise Manager to check again to see if my records are there - THEY
ARE!

Yet when I execute even a basic select query in access or a view in sql....
I get back not the 14k records that are shown for that value in the
[TumorTable] but 217... if I add any more fields to search on I get returned
0. Yep, zero.
 
Some steps I would do first:

You of course did a compact and repair?

You queried on one field in all 4 linked tables separately to isolate the
problem?

and imported the 4 linked tables and tried the sql on those imported tables?

Deleted half of the rows in a test DB and tried again?

Tried selecting only the top 100 rows?

Really simplify the SQL (though you said you did) maybe one table again.
Just pick the first field in each table.

Refresh/Recreate the connection to the linked tables.

Run linked table manager and check the links out - what they are pointing
to.

....

Hope it helps.
 
Back
Top