Be aware that you have several reserved words in your table designs.


Click image for larger version. 

Name:	ReservedWords.png 
Views:	6 
Size:	241.2 KB 
ID:	37004
See Problem names and reserved words in Access


Also, it is NOT a good idea to use spaces in object names.......