Access 2003 Crashes when I delete a record

[ccento]

I am deleting records from a table. I can usually delete the first one, and
then when I delete the 2nd one, Access crashes. Every time. I'm at SP3, have
turned off cascading deletes, have compacted and repaired the db several
times.

This is a new problem. I used to be able to delete records without a
problem. Any ideas?

 

[Arvin Meyer [MVP]]

There are a number of problems with SP3, but Microsoft has issued a hotfix.
Read these 2 articles from the Microsoft Knowledge Base:

http://support.microsoft.com/kb/923618

http://support.microsoft.com/kb/945674

 

[ccento]

I applied the hotfix and it did not fix my problem. Any other ideas?

 

[Arvin Meyer [MVP]]

Assume that the database has some corruption. I'd create a new, empty
database and import the table(s) with the problem, one at a time. Then
import everything else enmasse. Make sure you set references in the new one
to be the same as the old, since they don't automatically import.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[ccento]

I did that. Followed the instructions to create a new table, copy/paste the
data, then create a new db, etc... and I thought it was fixed. So, I started
deleting duplicate records without a problem. But, on my 10th one, going back
and forth between queries to find the duplicates and then my table to delete
them, it crashed again. Any answers?

 

[alex]

Hello,

I did that. Followed the instructions to create a new table, copy/paste
the
data, then create a new db, etc... and I thought it was fixed. So, I
started
deleting duplicate records without a problem. But, on my 10th one, going
back
and forth between queries to find the duplicates and then my table to
delete
them, it crashed again. Any answers?

 

[Ducuing]

salut ca va je suis francais

Hello,

 

[sergio]

salut ca va je suis francais

 

[ccento]

I'm still looking for some help. I created a new db (following the
instructions to fix a corrupt db) and had the same problem. Any other ideas?

Thanks,

Carrie