Hi Guys,
I have developed an MS Access database (2016 Version) consisting of tables, sqls, vba and macros for my team. The next challenge is, my team is consisting of about 40 associates and they need to update this database on a daily basis.
So far, my thought process is to split the database, keep the primary file in the shared drive and share the front end through email so that all of my associates have their own front end copy.
Please advise me if my approach is right and if not, then what could be an alternative best method to make this file shared for multiple users.
Thanks in advance for all your suggestions.
Regards,
Rakesh
I have developed an MS Access database (2016 Version) consisting of tables, sqls, vba and macros for my team. The next challenge is, my team is consisting of about 40 associates and they need to update this database on a daily basis.
So far, my thought process is to split the database, keep the primary file in the shared drive and share the front end through email so that all of my associates have their own front end copy.
Please advise me if my approach is right and if not, then what could be an alternative best method to make this file shared for multiple users.
Thanks in advance for all your suggestions.
Regards,
Rakesh