New Records Missing from Queries, Reports

[Craig S]

I built a complete Access database program with queries,
forms, reports... I then imported data into a database
from Works 4.5 and added new additional records to the
Access database. All records, new and imported show up on
all forms and tables. When I run reports, though, only
the imported records show up. The reports do, however,
show any changes that I made to the imported records but
the new records I added are not being picked up by my
queries, and thus not by their corresponding reports
either. Only the records that were imported are being
read by the queries. The forms work fine, the only (big)
problem is with the queries/reports.

 

[Tom Ellison]

Dear Craig:

There are several possible reasons for this. I'll make suggestion first how
you might try to narrow this down so you can soon put your finger on it.

Create a new query that access just one of the tables at a time, like:

SELECT * FROM YourTable

Look in that to see if the new records are there. From opening the table
get the total number of rows and compare to this query's total number of
rows. If both are referencing the same table there can hardly be any
difference, but let's make sure.

Starting from that point, slowly reconstruct the query that is behind what
is not now working. Not knowing what this is, I cannot be specific. But
when you find at what point it stops working (keeping an eye all the time on
the number of rows returned) you will have an excellent clue as to what went
wrong.

I'll also offer a guess as to just what it may be. If the non-working
queries have a join between tables, and you are using autonumber primary
keys, then the references to these are likely all broken. When you import,
Access must assign new autonumber values, while your imported values are
retaining their old reference values.

Please let me know if this helped, and if I can be of any other assistance.