queries not updating

[Guest]

Hi,

None of my queries are updating the data anymore. As new records are being
added they are not showing in any reports or queries. To my knowledge
nothing has changed in the database. Where do even begin to troubleshoot
this?

Thanks!

 

[Guest]

1.Check the table(s) to see if the data is there.

2. Save your query with a new name

3. I would start by removing one seciton of your criteria in the query and
running the query after each delete checking to see if your result is
attained. Repeat until you no longer have criteria or your desired result
comes up (remember you will not be filtering based on the criteria you
delete). If you get down to no criteria you know it must be a join issue.
Deconstructing the query will often help to understand the reason it
no-longer functions (or never did).

4. Delete the joins and tables from your query like you did the criteria.

At some point your query might just represent your table.

 

[John Vinson]

Hi,

None of my queries are updating the data anymore. As new records are being
added they are not showing in any reports or queries. To my knowledge
nothing has changed in the database. Where do even begin to troubleshoot
this?

Thanks!

Start with the definitions of the queries. Open the query datasheet
view; do you see the *> new record at the bottom? Is the query in fact
linked to the table that you think it is?

John W. Vinson[MVP]

 

[Guest]

I guess I should clarify. I did do some inital troubleshooting. I tried to
re-create a couple of the queries from scratch and I got the same results.
One of them is very basic and only uses 1 table, so there isn't much to it.
I may have figured out the problem though. I wasn't the creator of the
database, someone else created it and I have since taken it over. The inital
data was imported from Excel and he had an 'import ID' column in the main
table. It seemd that anything that had a 0 in that field was not being
figured in any query and I never created a query that was using that field.
I made a copy of the database before I started playing and deleted that
field from the table. All seems well now. I'm not sure why because like I
said none of the queries were using that field, it wasn't a primary key or
even joined to anything else either.

 

[dbahooker]

i'd reccomend using ACCESS DATA PROJECTS

you dont see this type of flakiness with a real query engine