Same Table - Different Users see different data

[kamathmanoj]

Just when I think I have seen it all, Access throws me a curve ball. Here is the latest one:

I have two users on the same domain. They both access the same database and the same table but they see totally different data in the same table.



One sees data only until 2015, the other sees data until the present date. What is happening??? Please help. I have torn my hair out trying to figure this out.

[June7]

Need to know your data structure, form design, code.

Is this a split design db? Each user runs their own copy of frontend?

If you want to provide db for analysis, follow instructions at bottom of my post.

[kamathmanoj]

Need to know your data structure, form design, code.

Is this a split design db? Each user runs their own copy of frontend?

If you want to provide db for analysis, follow instructions at bottom of my post.

Hi June,

Can not provide DB - its a production database. I am referring to the back end table. Only certain users are able to open this table (with production data) and see it all the way to the current date - same with the reports. I can see data only until 2015 and even the reports. I checked the MS Access Security and can confirm that the users that can see the data and myself are in the same user group.

[CJ_London]

I can see data only until 2015 and even the reports.

how are you seeing the data - looking at the table directly? through a form? report? if form or report, provide the details requested by June.

[Micron]

As far as I can tell, this question was not answered

Is this a split design db? Each user runs their own copy of frontend?

This would not be the first time that someone posted a similar problem only to eventually find that each user was attached to a different be table. Of course this would not be the case if it was a shared front end, so please answer the questions posed so that the focus of answers can be more precise.

I checked the MS Access Security and can confirm that the users that can see the data and myself are in the same user group.

What does this mean? I see by your info that you use A 2013 but are you saying the problem db is an older version and uses a workgroup (mdw) file?

[ArviLaanemets]

A possible scenario:
You had a split database with BE in shared network resource X1;
Sometimes in year 2015 the BE was removed to new shared network resource X2 (or new backend with different name was created);
For some users, their FE was updated with new BE in X2. For some users, FE was not updated, and is linked to shared network resource in X1 (or FE was overwritten with some old copy from year 2015).

There are other possible causes, but having the time difference ~4 years, this one looks as best shot.

[kamathmanoj]

how are you seeing the data - looking at the table directly? through a form? report? if form or report, provide the details requested by June.

I am going to try to answer all the questions one by one. @Ajax - I am looking at the table directly.

[orange]

Suggest you respond to all the questions in 1 post.

[CJ_London]

I am looking at the table directly

when you do respond - please clarify - you have opened the back end, then opened the table. Not opened the table via a linked table in your front end

[kamathmanoj]

As far as I can tell, this question was not answered :

Is this a split design db? Each user runs their own copy of frontend?"

Indeed it is but I am not using any frontend. I am in the backend. I checked the Linked Table manager and tried to get at the source of the data. all I and some users see is part of the table (from 2017 through May 16th 2019). Others (I logged in at their station) when I open the backend from the same shared location have data up until yesterday.

This would not be the first time that someone posted a similar problem only to eventually find that each user was attached to a different be table. Of course this would not be the case if it was a shared front end, so please answer the questions posed so that the focus of answers can be more precise.
What does this mean? I see by your info that you use A 2013 but are you saying the problem db is an older version and uses a workgroup (mdw) file?

Agree that this could have been the case but it is not. I can assure you I am using the backend and I have checked it on multiple PC's. I am using Access 2003 and it is an MDB file.

[CJ_London]

comments like this

Indeed it is but I am not using any frontend. I am in the backend. I checked the Linked Table manager and tried to get at the source of the data.

only serve to confuse.

If you are in the backend, the linked table manager will be irrelevant, there won't be any linked tables. Or are you saying you checked the users front end linked table manager to confirm they are linking to the correct file?

[orange]

When you look at the backend file from the different PCs is the last modified date consistent/the same?
Can you add a test record and view that record from all the PCs?
Do you have a maintenance or test facility that you can check/step through the code? from different PCs?

What distinguishes this "some " from the others??
"all I and some users see is part of the table"

[ArviLaanemets]

1. Open FE of user having data correctly displayed in design mode;
2. Activate Linked Table Manager in this FE, and write down path and name of BE file (or BE files in case you have several of them);
3. In case BE file path links to mapped drive, write down real path (\\ServerName\DrivePath) of mapped drive;
4. Open FE of user having incorrect data in design mode, and compare path and name [and drive mapping info] of BE file with first one. Do same for all FE's which display incorrect data.