Access 97 less available records

I am running a bespoke access 97 application (front on windows XP
machines, back end on Win 2000 server) that runs fine on 14 of 15 new
machines the 15th however apparently runs okay until you check the
record count which is always about 20% of the "okay" machines! I've
looked and checked everything I can think of, it's running exactly the
same DB so why this problem.

If anybody has any ideas I would be most grateful - it has been
suggested to me to install Access 97 Service pack 1 but I can't find
that either so any help at all would be fantastic.

re: Access 97 less available records

Have you saved a filter on the problem machine.

If you open the tables from the database window do you see the correct
data? (Make sure the navigation buttons do not say (Filtered).

If it's still wrong then my guess is that that machine is connected to a
different backend file. So use the Linked tables manager to relink.

Peter Russell


Jonny Archer previously wrote:
[color=blue]
> I am running a bespoke access 97 application (front on windows XP
> machines, back end on Win 2000 server) that runs fine on 14 of 15 new
> machines the 15th however apparently runs okay until you check the
> record count which is always about 20% of the "okay" machines! I've
> looked and checked everything I can think of, it's running exactly the
> same DB so why this problem.
>
> If anybody has any ideas I would be most grateful - it has been
> suggested to me to install Access 97 Service pack 1 but I can't find
> that either so any help at all would be fantastic.
>[/color]

re: Access 97 less available records

jonathan.archer@calibreinfo.co.uk (Jonny Archer) wrote in message news:<3d86f0ea.0402100414.21b34373@posting.google. com>...

I should have mentioned but I have already tried those potential
solutions - the front end has been relinked several times and is
identical to other machines in every way and a filter is not causing
the problem because the application automatically replaces any filters
with the standard filter used by the program.

[color=blue]
> I am running a bespoke access 97 application (front on windows XP
> machines, back end on Win 2000 server) that runs fine on 14 of 15 new
> machines the 15th however apparently runs okay until you check the
> record count which is always about 20% of the "okay" machines! I've
> looked and checked everything I can think of, it's running exactly the
> same DB so why this problem.
>
> If anybody has any ideas I would be most grateful - it has been
> suggested to me to install Access 97 Service pack 1 but I can't find
> that either so any help at all would be fantastic.[/color]

re: Access 97 less available records

I suggest that you create brand new link (using File>GetExternalData>Link)
to link to a table that you believe is not showing all data.
If this new link is still problematic and you have looked at the data in
the backend and it is correct then I would still have to conclude
you are looking at the wrong datafile from your front-end.

Are you specifying links using UNC addresses
(\\servername\pathtofile_be.mdb\file_be.mdb)
or mapped drives?
If mapped drives check the mapping from that machine.

Peter Russell

Jonny Archer previously wrote:
[color=blue]
> jonathan.archer@calibreinfo.co.uk (Jonny Archer) wrote in message
> news:<3d86f0ea.0402100414.21b34373@posting.google. com>...
>
> I should have mentioned but I have already tried those potential
> solutions - the front end has been relinked several times and is
> identical to other machines in every way and a filter is not causing
> the problem because the application automatically replaces any filters
> with the standard filter used by the program.
>[/color]