I have here an Excel Workbook that has forms and that has 1 sheet that is connected to Access Database (1 table only). I linked it by finding the Excel sheet path.
I can see that whatever data I add in Excel sheet, it reflects to Access database and it's good. I am not using Access Database queries to run my Excel form. I only use Excel VBA codes for my form.
Now, I want to send my colleagues via email a copy of the Excel Workbook which has a sheet that is connected to Access Database and simply let them use it to also save data in the same Access Database table. Here are my questions since I have not done this before.
1. Should I send the Excel Workbook together with Access Database?
2. I tried to upload the Access Database table to SharePoint. It was a successful upload. I tried to add data to the Excel Sheet and see if SharePoint also updates (since I already uploaded the Access Database). But as I checked/refreshed SP. It was not updated.
My one and only purpose: add a row of data to Excel sheet that should reflect in Access DB and SharePoint List
Please advise.