Multi users - different versions, problem with reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multi user database designed in XP, 2000 file format split into
front end, back end, works absolutely fine. However I've recently had to put
this on a laptop which only has Access 2000.

Some of the reports now only show half the data and seems to be showing data
from 1 table but not linked table (Invoices and Company Details tables are in
use and only info from Invoice table is there)

Tried it on another PC under 2000 and same problem; works fine on 2003 and
XP. Is there an incompatibility with 2000 - I see a few other queries along
the same lines but can't find any definitive answer or solution so any help
much appreciated.

Sheila
 
It should be possible to get this to work correctly, but it may be hard to
trace the issue.

Firstly, make sure that you have the correct service patches on the A2000
machines. Under Help | About, you should see:
MS Access 2000 (9.0.6926 SP-3)
If you have a smaller minor version, or don't see the SP3, get the update
from:
http://support.microsoft.com/gp/sp
While you are there, get the SP8 for JET 4. JET is the data engine in
Access, so it is just as important to keep it up to date. You can check what
version you have by locating msjet40.dll (typically in windows\system32);
then right-click and under Properties, check the Version tab.

If the versions are up to date, the next issue is that Access 2002 uses a
different binary than 2000. If you have developed or modified the file in
2002, it is quite common for 2000 to then have problems with it. The
solution is to decompile the database and compile it using the lowest
version. To decompile, close Access, and at the command prompt enter the
full path to the Access 2000 executable, with the decompile switch, and the
full name of your database--something like this:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
That's all one line, and include the quotes.
Then open in Access 2000, and compact:
Tools | Database Utilities | Compact
Then open a code window, and choose Compile from the Debug menu.

If the reports are still failing after this, post a reply to this thread for
more info.
 
First thing to check would be the Service Pack level of the Access 2000 --
there are three SPs for A2000, and additional patches. Make certain they are
all applied, as well as all SPs for the Jet database engine.

I don't know of any inherent difference in reporting that would cause the
effect you describe. I do know that A2000 had a number of problems when
first released -- it really needed the Service Packs that were later made
available.

Larry Linson
Microsoft Access MVP
 
Many thanks for info, most useful

Sheila

Allen Browne said:
It should be possible to get this to work correctly, but it may be hard to
trace the issue.

Firstly, make sure that you have the correct service patches on the A2000
machines. Under Help | About, you should see:
MS Access 2000 (9.0.6926 SP-3)
If you have a smaller minor version, or don't see the SP3, get the update
from:
http://support.microsoft.com/gp/sp
While you are there, get the SP8 for JET 4. JET is the data engine in
Access, so it is just as important to keep it up to date. You can check what
version you have by locating msjet40.dll (typically in windows\system32);
then right-click and under Properties, check the Version tab.

If the versions are up to date, the next issue is that Access 2002 uses a
different binary than 2000. If you have developed or modified the file in
2002, it is quite common for 2000 to then have problems with it. The
solution is to decompile the database and compile it using the lowest
version. To decompile, close Access, and at the command prompt enter the
full path to the Access 2000 executable, with the decompile switch, and the
full name of your database--something like this:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
That's all one line, and include the quotes.
Then open in Access 2000, and compact:
Tools | Database Utilities | Compact
Then open a code window, and choose Compile from the Debug menu.

If the reports are still failing after this, post a reply to this thread for
more info.
Click to expand...
 
Back
Top