Under what conditions will a query work on one machine but not ano

[Soma_rich]

I have a query that works exacly as expected (Its just a simple select) but
will not work on a collegues. He has the same OS and the same version of
Access, we have the same file structure and all the other quries (some a lot
more complex) work with no problems.

So what should I be looking for? what could possible be set incorectly?
Thanks

 

[Allen Browne]

First thing to check would be the version of JET.

Locate msjet40.dll (typically in windows\system32.)
Right-click and choose Properties.
On the Version tab, you see the major version (4), and the minor version
(should start with 8 or 9, depending on your o/s.), e.g.:
4.0.8106.0
If the minor version starts with a number less than 8, get the patch from:
http://support.microsoft.com/kb/239114

Next possibility is a difference in locale.
Open the Windows Control Panel.
Under Regional Settings, what differences are there?

You can actually minimize the differences in regional settings if you
declare your non-text parameters, and typecast your calculated query fields
as described here:
http://allenbrowne.com/ser-45.html
and handle your dates like this:
http://allenbrowne.com/ser-36.html

Another option is the setting under:
Tools | Options | General | Database sort order

If the query uses VBA functions, another possibility is differences in
library references:
http://allenbrowne.com/ser-38.html

Next, is the possiblility that Access is confused about the names used in
the query. Name AutoCorrect can do that:
http://allenbrowne.com/bug-03.html
So can using reserved words as field/table names:
http://allenbrowne.com/AppIssueBadWord.html

If you're still stuck, post the SQL statement that yields different results.

 

[Soma_rich]

Hi Allen,
Some very useful bits there I will go and check them. Here is the SQL (I did
say it was simple)
SELECT TopoJobDetails.JobNumber,
CountActTopoFlyingExclusive.CountOfActFlying,
CountEstTopoFlyingExclusive.CountOfEstFlying
FROM (TopoJobDetails LEFT JOIN CountActTopoFlyingExclusive ON
TopoJobDetails.JobNumber = CountActTopoFlyingExclusive.JobNumber) LEFT JOIN
CountEstTopoFlyingExclusive ON TopoJobDetails.JobNumber =
CountEstTopoFlyingExclusive.JobNumber
GROUP BY TopoJobDetails.JobNumber,
CountActTopoFlyingExclusive.CountOfActFlying,
CountEstTopoFlyingExclusive.CountOfEstFlying;

Thank you
Rich

 

[Soma_rich]

Got it! I had version 4 of Jet after installing that patch everything is
working fine.
Thanks Allen.

 

[Allen Browne]

That's great news!