Step by step in excruciating detail, walk through what happens and where it breaks for the second user.
Here goes:
This is a specific example, but if the user updates any of the linked .MDB files, it is the same occurence.
1. .MDB is updated via export from CRM. .MDB file has three tables. All are updated successfully.
2.Within the .accdb (file that uses the .MDB files as data sources and builds reports), the related tables also successfully get updated.
3. Next is the query that ties in SolicitorGoals (this data does not change) :
Solicitor Goals Query:
SELECT TOP 1 [Solicitor]![CnBio_First_Name]+" "+[Solicitor]![CnBio_Last_Name] AS Solicitor, SolicitorGoals.CnGoal_1_Category, SolicitorGoals.CnGoal_1_Goal, SolicitorGoals.CnGoal_1_Notes
FROM (SolicitorGoalLink INNER JOIN Solicitor ON SolicitorGoalLink.CnBio_LINK = Solicitor.CnBio_LINK) INNER JOIN SolicitorGoals ON SolicitorGoalLink.CnGoal_1_LINK = SolicitorGoals.CnGoal_1_LINK
GROUP BY [Solicitor]![CnBio_First_Name]+" "+[Solicitor]![CnBio_Last_Name], SolicitorGoals.CnGoal_1_Category, SolicitorGoals.CnGoal_1_Goal, SolicitorGoals.CnGoal_1_Notes
HAVING (((SolicitorGoals.CnGoal_1_Category)="Monthly Meeting Goal" Or (SolicitorGoals.CnGoal_1_Category)="Annual Fundraising Goal"))
ORDER BY SolicitorGoals.CnGoal_1_Notes DESC;
Solicitor Gifts Raised:
SELECT GiftSolicitor.GfSol_1_Name AS Solicitor, GiftSolicitor.GfSol_1_Amount AS SolicitorAmount, Gifts.Gf_Date AS DateRaised, [Solicitor Goals].CnGoal_1_Goal AS Goal, [Department Goal].DepartmentGoal, Gifts.Gf_Amount AS [Gift Amount], Gifts.Gf_GftsLnkdtPlnndGft
FROM [Department Goal], (Gifts INNER JOIN GiftSolicitor ON Gifts.GfSol_1_LINK = GiftSolicitor.GfSol_1_LINK) INNER JOIN [Solicitor Goals] ON GiftSolicitor.GfSol_1_Name = [Solicitor Goals].Solicitor
WHERE (((GiftSolicitor.GfSol_1_Name) Is Not Null And (GiftSolicitor.GfSol_1_Name)<>"Betsy Clardy") AND ((Gifts.Gf_GftsLnkdtPlnndGft)=No) AND (([Solicitor Goals].CnGoal_1_Category)="Annual Fundraising Goal"))
ORDER BY [Solicitor Goals].CnGoal_1_Goal DESC;
As a reminder, if I remove the Department Goal query from my design, it does not fix the problem.
When the user goes to view the Solicitor Gifts Raised query, only column headers appear. There is not data in the cells.
Let me know if you have further questions on the set up. I'm having my IT team compare user permissions this afternoon.