Hi,
I have an excel workbook that allows users to enter information into a form and send it to a back-end Access Database. It works just fine when it is in a normal folder but I have posted it to a SharePoint site and now notice that when the information is entered on the form and submitted, it is not storing the data to the Access Table.
The field titles have not changed and it was working perfectly when stored in a regularfolder. Not sure if there are certain permissions that need to be altered or even additional VBA code to help feed it through?
Any help would be much appreciated!
I have an excel workbook that allows users to enter information into a form and send it to a back-end Access Database. It works just fine when it is in a normal folder but I have posted it to a SharePoint site and now notice that when the information is entered on the form and submitted, it is not storing the data to the Access Table.
The field titles have not changed and it was working perfectly when stored in a regularfolder. Not sure if there are certain permissions that need to be altered or even additional VBA code to help feed it through?
Any help would be much appreciated!
