I have a access_database which keeps on my own computer and another access_file which I use as a database to work with Excel dashboard, therefore everytime the user on dashboard selects a new filter, the VBA takes the information from this access_file to pull data, BUT my question is: Is there anyway to link automatically the access_file to access_database? Because every time I update the original file, I need to upload for the users to download once again.
The flow would be, just to make easier:
1) I update the access_database;
2) It is linked via tables from access_database to acess_file which the access_file the users download;
Thank you!