I have a SharePoint site with 10 to 15 lists that are all linked to eachother with a couple of lookup fields. When I try to import it into Access, many times Access just hangs, and stops responding.
Sometimes I succeed, and when I then review the relations screen, it looks like Access is making a mess out of all relationships, and creating all kinds of linked tables multiple times.
Any clue how I can solve this? We really need this linked tables into our Access solution in a stable way.
See the following screenshot: