Re: Multi users - different versions, problem with reports
- From: "Sheila D" <SheilaD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 23:53:03 -0700
Many thanks for info, most useful
Sheila
"Allen Browne" wrote:
> 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
>
>
>
.
- References:
- Multi users - different versions, problem with reports
- From: Sheila D
- Re: Multi users - different versions, problem with reports
- From: Allen Browne
- Multi users - different versions, problem with reports
- Prev by Date: superscript
- Next by Date: Re: superscript
- Previous by thread: Re: Multi users - different versions, problem with reports
- Next by thread: Re: Multi users - different versions, problem with reports
- Index(es):
Relevant Pages
|
