Re: Multi users - different versions, problem with reports

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.

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

"Sheila D" <SheilaD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A65214F2-A2A2-497F-9948-563E004DE8BB@xxxxxxxxxxxxxxxx
>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


.

Relevant Pages

  • Re: 2002 database corrupt and unuseable after upgrading to Access
    ... I decided to try the decompile on A2003 after ... rather than allenbrowne at mvps dot org. ... >> The database has an autostart form which displays a few seconds, ... >> Opening the database with the shift key down bypasses the autostart form, ...
    (microsoft.public.access.conversion)
  • Re: Unwanted break mode @ startup Access 2K
    ... > This can happen if the project is partially corrupt, and a Decompile ... Compact the database to get rid of this junk: ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2003 Downwards Compatibility
    ... decompiled the database in Access ... 2000, checked at Access 2003 the references, but no ... To decompile, enter ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Database Model - Class, objects and interaction
    ... invoices that are not payed. ... The problems with stored procedures is that they are not possible to ... Be aware that the only responsibility for the database is to guarantee ... example no disk access or index usage is exposed when using SQL. ...
    (comp.object)
  • Re: Business objects, subset of collection
    ... SQL only works when the statements are ... all items (invoices) are subscribing for events. ... all items and all items has to execute the criteria evaluation, ... The features of a OO database is basically the same as of a network ...
    (comp.object)