By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

queries doesn't return new records

P: n/a

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.


Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.