Access crashes when query results are copied.

[Chris Hankey]

I having a strange and annoying problem where Access crashes when the
user copies (to the clipboard) the results of a query. The message is
not very helpful. It simply says - "Microsoft Access has encountered
a problem and needs to close. We are sorry for the inconvienience".

The MDB is the front-end portion of an Access application. Most of
the tables are linked to the back end. Including the tables used to
generate the query in question. There are a couple of local tables
that have user preferences. Most of the queries that the users run
use the query by form technique. Overall the application is pretty
simple.

Some of the users have been using the same copy of the front-end. My
theory is that this is causing the front-end to become corrupt. I am
hoping that this problem will go away if all users use there own copy
of the front-end. Has anyone seen this problem? Any help or
suggestions would be appreciated. One quirk is that the error does
not occur consistently on everyone's PC, even if they are using the
same copy of the front-end.

 

[Guest]

hi,
try load a copy of the front end on each users machine.

 

[Guest]

I'm running into a similar problem except I'm not getting a message. The
users successfully copy/paste but they cannot
close the query - Access appears to quit responding. I found
that if I cleared the contents of the clipboard and then closed the
Access query that it works. Now I need to find out how to clear
the clipboard via code. I'll be posting my question to the programming board.