Access crashes when adding linked tables to query grid

[Mike Ridley]

I am trying to create a new query using 3 linked tables. As soon as I
add the third table to the design grid Access crashes.
I have looked in the newsgroup and find that there have been problems
with linked tables and Access 2000 but the threads are dated about 3
years ago.
I am running XP Home Edition Version 2002 SP1 and Access 2002
(10.2627.2625).
I have checked on the Microsoft Upgrade site and although upgrades are
available they all seem to be about security and don't mention linked
table problems.

Any help would be appreciated.

Mike

[Allen Browne]

Try this article:
Access Quits Unexpectedly When You Run a Query
at:
http://support.microsoft.com/?id=322794

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mike Ridley" <gi******@hotmail.com> wrote in message
news:e5**************************@posting.google.c om...

I am trying to create a new query using 3 linked tables. As soon as I
add the third table to the design grid Access crashes.
I have looked in the newsgroup and find that there have been problems
with linked tables and Access 2000 but the threads are dated about 3
years ago.
I am running XP Home Edition Version 2002 SP1 and Access 2002
(10.2627.2625).
I have checked on the Microsoft Upgrade site and although upgrades are
available they all seem to be about security and don't mention linked
table problems.

Any help would be appreciated.

Mike