This has been a recurrent problem I have never been able to resolve. I have an index in one of my tables that corrupts intermittedly. When it corrupts, it does any of the following:
* Doesn't enter a record in at all
* Adds new records on a linked subform (the subform goes to a table with the department names in it--it adds department names)
* Deletes the record when the archive queries are run (an append and delete query)--but doesn't append it
* Triggers an Error 2105--can't go to a specified record
* Triggers an Error message saying that it can't create the record because it would create duplicate values
I have run repair and compact; imported the database into a new database; created a duplicate of the table and imported the records into it. All of these fix the problem temporarily, but the index continues to periodically corrupt. Is there anything else I can do to permanently fix it?
Linda Adams
Visit my web site for writing and Microsoft Word tips: Official web site for actor David Hedison:
* Doesn't enter a record in at all
* Adds new records on a linked subform (the subform goes to a table with the department names in it--it adds department names)
* Deletes the record when the archive queries are run (an append and delete query)--but doesn't append it
* Triggers an Error 2105--can't go to a specified record
* Triggers an Error message saying that it can't create the record because it would create duplicate values
I have run repair and compact; imported the database into a new database; created a duplicate of the table and imported the records into it. All of these fix the problem temporarily, but the index continues to periodically corrupt. Is there anything else I can do to permanently fix it?
Linda Adams
Visit my web site for writing and Microsoft Word tips: Official web site for actor David Hedison: