Question Bizzare Multiuser Problem

[MKOC]

I am having a problem with a multiuser Access database and I am hoping you can help.
· There are 5 computers attached to a server with MS Server 2008
· Access itself is server based
· The database file is on the server and it is split into a front and backend.
· Person A on computer 1 sees 164 records
· Person B on computer 2 sees only 22 records. This is true even if only one person is accessing the file. Also, the records that person B sees are not in the records that person A sees.
· Persons C, D, and E on computers 3, 4, and 5 only see the 22 records as well. If person B adds records, persons C, D, and E will see the changes but person A will not.
· If person A logs onto computer 2, they only see the 22 records.
· If person B logs on to computer 1, they can only see 22 records.
· If the administrator logs onto the server, they see 164 records but not the other 22.
· I have checked permissions for all the users and computers and they are all the same.
· The users only have local profiles not global profiles
· There are no other Access database files anywhere on the server
· There are no database files saved locally

Any ideas?
Thanks.

 

[bob fitz]

With a split db each user needs to have and use a copy of the front end on their own machine.

 

[MKOC]

Bob,

Thank you for getting back to me. I tried what you suggested but I am still having the same problem. Any other ideas?

Thanks.

Maura

 

[jdraw]

Did you have a copy of the FE on each user's PC? Each user has their own copy of the FE. It sounds that the FE and BE are both on the server.
Please clarify.

 

[MKOC]

Yes, it is true that both files were on the server. But when I copied the FE file to the desktop, I still had the same problem.

Thanks.

Maura

 

[Catalina]

The 164 and 22 records that can be seen, are they random or the same ones after every login?

Could it be a query that filters out certain records?

Catalina