Hi Mike,
I have noticed that there was no reply to this post. My apologies for the late response here, and to follow up - it is not possible to do a direct connection to your database in MS Access. An alternative could be to use the API to retrieve datasets from your company account, and then bring these datasets into your database as required.
Documnetation for the API can be found here.