Too many Queries?

[Ernst]

I was trying to access a database that I am building and
for some strange reason, it became corrupted. Before I
start from scratch I would like to know if there is a
rule for using too many queries because there must have
been six hundred. If this is not the reason why the
database crashed I will use the save method.

Thanks

 

[John Vinson]

I was trying to access a database that I am building and
for some strange reason, it became corrupted. Before I
start from scratch I would like to know if there is a
rule for using too many queries because there must have
been six hundred. If this is not the reason why the
database crashed I will use the save method.

Thanks

There is some huge - tens of thousands - limit on the total number of
objects in a database. 600 queries is nowhere near pushing this limit.

Corruption happens. See Tony Toews' excellent Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm - at the moment it
seems to be down for maintenance but I expect it'll be back up soon.

Note that it is ABSOLUTELY essential to regularly Compact your
database; in Access 2000 and later, it seems to be valuable to
occasionally create a new, empty database and import all your objects,
since the compaction process seems to miss some garbage. Doing so
should lessen the risk of corruption. And regular backups are, of
course, absolutely required.