How to install unmatched wizard?

[bez999]

Hello
I am using Office 2003 on XP and in Access queries the unmatched wizard is missing.
I have been through the custom install process and selected the wizards to be installed but they have not installed.
Does anyone have any idea what I am doing wrong, please?

Regards
Chris

Regards
Chris Bezant

 

[THWatson]

Chris
See if this article on the Microsoft site helps.

http://office.microsoft.com/en-us/access/HP051864641033.aspx?pid=CH062526071033

I notice there is a "what if a wizard doesn't start" answer.

Tom

 

[bez999]

Thanks for the reply, Tom.

I had a trawl through that stuff and it talks about Jet 4 but as far as I can tell my 2003 Access is using Jet2x and Jet3x.

Do you know if it is possible to run the unmatched wizard from anywhere other than the queries database window?


Regards
Chris Bezant

 

[THWatson]

Chris
I don't use Access 2003, but I would have thought your version of Jet would have been 4.0

It could be that Jet has some damage. Here is a link that talks about repairing a damaged Jet

http://support.microsoft.com/kb/283849/en-us

I'm not aware of a way to run the unmatched wizard from elsewhere, however you could make it up yourself.

Here is an example SQL which finds records in tblTrinity where there are no matches in tblChildren...

SELECT tblTrinity.UniqueID, tblTrinity.LastName, tblTrinity.FirstName
FROM tblTrinity LEFT JOIN tblChildren ON tblTrinity.UniqueID = tblChildren.MemberID
WHERE (((tblChildren.MemberID) Is Null));

Tom

 

[bez999]

Thanks, Tom.

Regards
Chris Bezant

 

[barny2006]

or you can use this:

SELECT tblTrinity.UniqueID, tblTrinity.LastName, tblTrinity.FirstName
FROM tblTrinity 
WHERE 
(EXISTS(SELECT tblchildren.memberid FROM tblchildren WHERE tblchildren.memberid = tbltrinity.uniqueid) = FALSE)