Currently we are using an excel file uploaded to sharepoint to log non conformance events. This file has to be checked out, filled in by a member of a team and then checked back in once updated.
The data is often really fragmented due to users not filling the file in correctly (just simple headers on columns which they fill in below.) I want to convert this file in to something a bit better for managing this type of data, which will be an access database.
If I were to build my database and split it in to a front end / back end would I be able to put the front end on sharepoint, which users can check out fill in the forms and submit data then check it back in? This would then be updating the backend which will be hosted on a server.
I just want to ensure that I do not create something where the whole database would have to be stuck on sharepoint as the file size no doubtedly will become huge. So a nice light weight front end feeding in to the heavy back would be ideal. We are using access 2003 and I have taken a look at using access data pages but I am now put off by the lack of support after 2003 for them.
The data is often really fragmented due to users not filling the file in correctly (just simple headers on columns which they fill in below.) I want to convert this file in to something a bit better for managing this type of data, which will be an access database.
If I were to build my database and split it in to a front end / back end would I be able to put the front end on sharepoint, which users can check out fill in the forms and submit data then check it back in? This would then be updating the backend which will be hosted on a server.
I just want to ensure that I do not create something where the whole database would have to be stuck on sharepoint as the file size no doubtedly will become huge. So a nice light weight front end feeding in to the heavy back would be ideal. We are using access 2003 and I have taken a look at using access data pages but I am now put off by the lack of support after 2003 for them.