We have several customers using a web-based software platform and they only have access to their own data after logging in. I have an Access file that is connected to the data from this web-based software platform. The connection is created using MySQL Connector/ODBC. I have customer specific Excel files that are connected to customer specific queries in the Access file. Each week, I open these Excel files, refresh the data, and send out an updated Excel file to each customer. I was wondering if it's possible to send customers an Access file that could be used for them to be able to update their own Excel data? The Access file would obviously need to be in a state which makes it impossible for them to have visibility to any data whatsoever.
It sounds scary having a connection out there to live data in our database, but was just wondering if it's possible to provide an Access file that is limited to only being a conduit for updating an Excel file. If not, does anyone have suggestions of ways to provide these customers with the ability to get current information in a secure manner?