Hi All,
first off, i don't really post here, but have frequented the forum a number of times, so thanks for the help thus far.
I have question about database design.
Currently i have set up that is an excel sheet using multiple macros to essentially replicate some of what a database would do. this sheet is used by myself and 7 other people (all located in different countries). The current sheet is stored on a shared google drive (team drive). This presents multiple problems, with versions / users overwriting each other etc etc. The 7 users all have a similar job to input data, which we then use to run various reports (the excel macros) on.
My suggestion is that we move to a split database. The backend hosted on the team google drive, with each of them using their own local copy of the front end. My question is can i utilize 'Microsoft Access 2016 Runtime' for their front end copies (they dont have a copy of access, which is the reason we went with excel originally) and will their be any potential problems having the backed on a shared google drive.
Any and all thoughts / suggestions welcome.
first off, i don't really post here, but have frequented the forum a number of times, so thanks for the help thus far.
I have question about database design.
Currently i have set up that is an excel sheet using multiple macros to essentially replicate some of what a database would do. this sheet is used by myself and 7 other people (all located in different countries). The current sheet is stored on a shared google drive (team drive). This presents multiple problems, with versions / users overwriting each other etc etc. The 7 users all have a similar job to input data, which we then use to run various reports (the excel macros) on.
My suggestion is that we move to a split database. The backend hosted on the team google drive, with each of them using their own local copy of the front end. My question is can i utilize 'Microsoft Access 2016 Runtime' for their front end copies (they dont have a copy of access, which is the reason we went with excel originally) and will their be any potential problems having the backed on a shared google drive.
Any and all thoughts / suggestions welcome.