Copy error in a select query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 30 Nov 2005 17:06 GMT

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

Reply to this Message

Marshall Barton - 30 Nov 2005 18:36 GMT

>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)
[quoted text clipped - 9 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message