By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,141 Members | 823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,141 IT Pros & Developers. It's quick & easy.

Access/Sharepoint best way to create a front end?

P: 374
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.
Jun 7 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.