That's a good sized table, but not a problem for A97.
If the database objects (tables, forms, code, ...) are not being modified,
then the corruption is most likely caused by the "inelegant shutdown":
hardware that hangs, power failure, impatient users who reset their computer
rather than wait for a process to finish, unstable network connections, etc.
Suggestions if the problem persists but you are sure none of the above
applies:
1. Make sure the database is split.
2. Avoid binding tables directly to a table with 450k rows. There are
performance and reliability issues and remnants of the bookmark bug with
recordsets that large. Ideally, change the RecordSource of the form so it
loads just one record at a time.
3. Try your tables without any memo, hyperlink, or OLE Object fields. Since
these are linked, there is a slightly increased risk of corruption.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Sudipto said:
I have a access 97 database having more than 450000 rows. Recently I found
out that some datas are missing and some data corruption has taken place. No
one has tampered with the data. Please advice My email address is
(e-mail address removed)
