queries doesn't return new records

[cedricg]

Hello,

I've got this behaviour recentely.

The database (access 2k) is used for an internet site using ado. There's a 5
tables, the most populate has 8500 records, and there's 3 queries saved
inside the database.

What happen, is that very often, I must "compact" the database, if not, the
queries doesn't return the newly created records. Once compacted, the
queries work as expected, until next time...

Also, perhaps I should precise that the big table, has a field of type memo.
Dont know if that could be the culprit.

Thanks.

cedric