Access select query -- invalid argument

[Ucaihc]

I use the following SQL statement in an Access query:

SELECT tblWWS_sch.*
FROM tblWWS_sch
WHERE (((tblWWS_sch.Archive)=0));

This work fine in one copy of the database with 13576 records. In another copy of the database with 14000+ reocrds, the query no longer works unless I omit the where clause. The field is a boolean.

 

[genomon]

Have you tried removing the parens from the WHERE clause?WHERE tblWWS_sch.Archive = 0;

I have great faith in fools; self-confidence my friends call it.
-Poe

 

[Golom]

What does "... no longer works ..." mean?

It returns no records?
It errors?
It returns the wrong records?

 

[Ucaihc]

I did a compact and repair on the back-end. Thank you