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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

"Allen Browne" wrote:

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.

--
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.

"Soma_rich" <Somarich@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85F09813-CFFE-4458-8ED6-AF662594A962@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Problem emailing query results
    ... This query generates only one ... Allen Browne - Microsoft MVP. ... "See attached blah blah", True ... assign it to the SQL property of the QueryDef before calling SendObject, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report Parameters - no results
    ... Allen Browne - Microsoft MVP. ... I did use the WHERE clause you suggested, and now I'm getting the "wrong ... > What else can I do to try to correct my sql? ... >> the WHERE clause in your query. ...
    (microsoft.public.access.reports)
  • Re: Need help with query linked to form.
    ... That message just means Access can't parse the SQL statement. ... Allen Browne - Microsoft MVP. ... In query design, choose Parameters on the Query Design tab of the ribbon ... Set the Format property of the text box on the form. ...
    (microsoft.public.access.queries)
  • Re: Create a list of dates from a query
    ... I used to work with sql that I could loop in. ... Allen Browne - Microsoft MVP. ... Use a counting table if you wish. ... You can then generate a query as: ...
    (microsoft.public.access.queries)
  • Re: Date Format complications
    ... The date display in the Query grid is confusing since it varies according to ... I use the SQL View to check date literals. ... SQL) MUST be in the US format mm/dd/yyyy and delimited by hashes ... *regardless* of your Regional Settings. ...
    (microsoft.public.access.queries)