Hi Everybody,
I learning MS Access and ive have been asked me to build a database, there will only be a handful of users and maybe a few thousand record entries. The users of the database will be at different locations and their computers are not networked, so Ive been thinking of putting the backend on the internet (maybe Azure?) and the front end at the local PC's as a solution so multiple users can use it. Also, there are word documents files that need to be accessed on local pc's ( word docs downloaded from email) and data pulled into the database, names, addresses etc - I'm not sure how to do this in vba. Ive written something in python that does this when the database and file are on the same pc but dont know if this works if the backend is on the internet. Any advice/guidance on placing the database on the internet and handling word docs over the internet would be great.
Thank you very much for any help. Sorry if Ive placed this question in the wrong Forum!
I learning MS Access and ive have been asked me to build a database, there will only be a handful of users and maybe a few thousand record entries. The users of the database will be at different locations and their computers are not networked, so Ive been thinking of putting the backend on the internet (maybe Azure?) and the front end at the local PC's as a solution so multiple users can use it. Also, there are word documents files that need to be accessed on local pc's ( word docs downloaded from email) and data pulled into the database, names, addresses etc - I'm not sure how to do this in vba. Ive written something in python that does this when the database and file are on the same pc but dont know if this works if the backend is on the internet. Any advice/guidance on placing the database on the internet and handling word docs over the internet would be great.
Thank you very much for any help. Sorry if Ive placed this question in the wrong Forum!