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" <gillingw@hotmail.com> wrote in message
news:e5f23f0e.0406180104.56e4eb54@posting.google.c om...[color=blue]
> 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[/color]
