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:

Click image for larger version. 

Name:	2015-10-07_1210.png 
Views:	15 
Size:	230.1 KB 
ID:	22311