Copy error in a select query

[Guest]

HI,

This is really strange, In a simple select query based on a single table,
after highlighting a row and then copying (Ctrl + C or by the edit menu)
Access will crash, then do a compact & repair. It's Acc2002, I am the
designer and it doesn't happen to me, however it happens to my users some
have Acc2002 fullversion, some have runtime. All use the .MDE.

The Error message is kinda vague, but is as follows:
Error Signature
AppName: Msaccess.exe
Modver: 10.0.4219.0
Appver: 10.0.4302.0
Offset: 00004d7a
Modname msd.dll


Any help would be greatly appreciated, I've search around Google groups and
MS sites and found nothing. Any ideas?

Thanks,
Phil

 

[Marshall Barton]

This is really strange, In a simple select query based on a single table,
after highlighting a row and then copying (Ctrl + C or by the edit menu)
Access will crash, then do a compact & repair. It's Acc2002, I am the
designer and it doesn't happen to me, however it happens to my users some
have Acc2002 fullversion, some have runtime. All use the .MDE.

The Error message is kinda vague, but is as follows:
Error Signature
AppName: Msaccess.exe
Modver: 10.0.4219.0
Appver: 10.0.4302.0
Offset: 00004d7a
Modname msd.dll

I've never seen a crash for a simple Copy, but I have had
Copy fail with strange error messages when the record was
corruptued.

If you have a good backup of the data mdb, check to see if
it happens there too.

Can you export the table to a new empty mdb file and copy it
from there?

If this is a case of corruption, then there will be a lot of
trial and error in attempting to recover the data. For some
guidlones, take a look at :
http://www.granite.ab.ca/access/corruptmdbs.htm