Hi,
I'm new, and I'm not sure if this has been asked before in this forum (if it's been inquired before, please direct me to the right forum/discussion thread) or if I even chose the right forum for this (kindly direct me to the right forum).
I have a project of reducing worksheets that we're using for various activities, by dumping them into one file. The initial idea is to use an Excel sheet for the job. The problem however is that we have more than 15 people who needs to use the file/tool simultaneously. And we've encountered a lot of issues with sharing an excel file (ex: the file is corrupted when the file is used simultaneously).
In our line of work, we access another computer remotely for crucial tasks. And that 2nd computer contains MS Access. Other teams in our office use it to track their tasks. But my team hasn't used it before (most of our members hadn't even heard about MS Access). The 2nd plan for my project was to create an MS Access database instead of an MS Excel file, since MS Access seems more built for file sharing.
Since we don't have MS Access in our primary computers, and most of our team members are not well-versed with MS Access and are more familiar with MS Excel navigation, I was wondering if it's possible for us to create an Excel Userform that can route data into an MS Access Database.
I've done some legwork about this, and I've read how it's more efficient to use MS Access for everything. I agree with that, but given the circumstances above, I'd still like to explore the idea of using MS Excel as a front-end, and MS Access as a back-end.
--Sorry if this is a mouthful, but I would greatly appreciate any urgent reply to this concern.
Thanks!
I'm new, and I'm not sure if this has been asked before in this forum (if it's been inquired before, please direct me to the right forum/discussion thread) or if I even chose the right forum for this (kindly direct me to the right forum).
I have a project of reducing worksheets that we're using for various activities, by dumping them into one file. The initial idea is to use an Excel sheet for the job. The problem however is that we have more than 15 people who needs to use the file/tool simultaneously. And we've encountered a lot of issues with sharing an excel file (ex: the file is corrupted when the file is used simultaneously).
In our line of work, we access another computer remotely for crucial tasks. And that 2nd computer contains MS Access. Other teams in our office use it to track their tasks. But my team hasn't used it before (most of our members hadn't even heard about MS Access). The 2nd plan for my project was to create an MS Access database instead of an MS Excel file, since MS Access seems more built for file sharing.
Since we don't have MS Access in our primary computers, and most of our team members are not well-versed with MS Access and are more familiar with MS Excel navigation, I was wondering if it's possible for us to create an Excel Userform that can route data into an MS Access Database.
I've done some legwork about this, and I've read how it's more efficient to use MS Access for everything. I agree with that, but given the circumstances above, I'd still like to explore the idea of using MS Excel as a front-end, and MS Access as a back-end.
--Sorry if this is a mouthful, but I would greatly appreciate any urgent reply to this concern.
Thanks!