By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Access crashes when query results are copied.

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In almost every case where I have encountered this error in A2002, it is
because a variable or function has been created that is the same as the name
of:

1. an Access reserved word
2. another variable or function
Darryl Kerkeslager
"Chris Hankey" <ch*****@aegonusa.com> wrote in message
news:38**************************@posting.google.c om...
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.

Nov 13 '05 #2

P: n/a
ch*****@aegonusa.com (Chris Hankey) wrote:
Some of the users have been using the same copy of the front-end.


A definate no-no. Also, have you implemented the changes detailed here?

<http://members.iinet.net.au/~allenbrowne/ser-48.html#usability>

Regards,
Keith.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.