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
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