I have a few SharePoint lists as the back end to several different Access Databases - each used by different people for different tasks so different queries and different forms as required.
One particular SharePoint List has 5858 entries on the website and the same in the linked table in one of my Access Databases.
BUT in another Access Database the linked table to the SAME SharePoint list has only 30 entries!!!!
No amount of unlinking & relinking this table has returned the missing data, nor compacting/reparing the database
All the other linked SharePoint Lists in the same Access database seem to be working fine.
Has anyone any ideas on how to fix the broken link? Ta