Re: problem with 2003 reports not matching

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

First thing to check is that the machines are all connected to the same data
file. You would not be the first to strike this kind of issue when some
machines are connected to a different back end file.

Next, open the back end, and try a repair:
Tools | Database Utilities | Compact And Repair
If the date field is indexed, and the index is damaged, this should fix the
problem.

There is actually a hotfix out that addresses records missing in a report in
A2003 after SP1 has been applied. Not sure this sounds like your issue, but
details at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;840656

If that does not solve the issue, double-check that the Name AutoCorrect
boxes are unchecked in all databases (the back end, and each front end)
under:
Tools | Options | General
It is possible for Access to misunderstand the basic names in the query if
this misfeature is on. More info:
http://allenbrowne.com/bug-03.html
Then compact again.

If the problem persists, the next thing to look for is different versions of
JET on the machines that return different results. JET is the query engine
in Access. Locate the file msjet40.dll, typically in \windows\system32.
Right-click it, and on the Version tab you should see 4.0.8xxx.0. The xxx
digits don't matter, but if you don't see the 8, download JET 4 SP 8 from:
http://support.microsoft.com/gp/sp

If you are still stuck, does the source query for the report return the
correct number of records?
- No: the problem is with JET drawing in the data. Post the SQL statement.
Check the service packs on the server.
- Yes: the problem is with the report presenting the data (e.g. code in the
report's events.)

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

"Chris Cowa" <chris.cowan@xxxxxxxxxxxx> wrote in message
news:uM9Q%23ilhFHA.2424@xxxxxxxxxxxxxxxxxxxxxxx
>I have an unusual problem. I have a DB that is split. It was created
> originally in Access 2000. We are now a mixed house of 2000 and 2003. The
> BE
> is on a server; wheras the MDB/MDE is on the users PC.
>
> Here is the problem.
>
> I have a report that runs that selects if a date is over due. In 2000 it
> shows 7 records, in 2003 it shows 5 records. Now here is the funny part. I
> have a test machine with XP OS and Access 2003 on it. It shows all 7
> records. whereas I have a Technician build 50 others that is similar. The
> report runs good on mine (7 records).
>
> I am trying to determine where in his setup that is different then mind.
> It's blowing my mind.
>
> I can take the same MDB and place on my 2000 system, my 2003 system and
> someone elses 2003 system. In the first 2 I get 7 records; in someone
> elses
> I get 5 records.
>
> Help
>
> Chris


.

Relevant Pages

  • RE: Query Report on specific file collected from client machines
    ... create the subselected query i get a error "Please enter a valid subselect ... query, because he does an excellent step-by-step how to create a subselect. ... I am hoping someone can assist in a query or report. ... Both results show which machines that are in this collection have the file ...
    (microsoft.public.sms.inventory)
  • Re: Differing results for the same report when run on different pc
    ... At least each user is opening a separate instance that way. ... then ran the query and got the same results. ... but I don't think that's likely as the 2 machines with the ... The report is based on a query and the query produces the same ...
    (microsoft.public.access.reports)
  • Re: Differing results for the same report when run on different pc
    ... Open the query in design view. ... Explicitly declare the parameters, by ... The report is based on a query and the query produces the same results ... Is there any difference with Regional Settings between the 2 machines? ...
    (microsoft.public.access.reports)
  • Re: Multiple Copies of a report
    ... That means the Master has its own separate copy of the SalesEntry ... Even if the query were misunderstanding the data type of the SalesRef field, ... We still have the fact that it works differently on the 2 machines. ... Report Name SalesInvoice ...
    (microsoft.public.access.reports)
  • Re: Software Update - Distribution Status; How is this reported back to SMS?
    ... Well I reinstalled Office2003 on one of the bad machines (using my own ... database as having Office2003 SP2. ... I've noticed that the client will report ... installed via Client Push Installation. ...
    (microsoft.public.sms.admin)