You may receive one of the following errors when connecting to Access:
System.Data.OleDb.OleDbException: System resource exceeded.
Receive Data Error
System.ApplicationException: System.ApplicationException: Access Import: SELECT * FROM [LookupTableQuery]
Note: This connection uses the Microsoft.ACE.OLEDB.12.0 driver which can be downloaded at http://www.microsoft.com/en-us/download/details.aspx?id=13255. ---> System.Data.OleDb.OleDbException: System resource exceeded.
This error indicates that Access does not have any connections available for Sync & Save to use. This may be caused by other applications leaving connections to Access open.
To resolve this issue, the machine hosting the Access database file will need to be restarted. This clears the record of Access connections.