Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need some good advise. I have used Access for many years and I use Sharepoint but never the two combined. My newly created Access db needs to be shared with many users across the organization. The back end is SQL and the old way to distribute the database would be placing the db on a shared drive, connecting their PC ODBC connections to the SQL db and then they would open the database and have at it. This has become the OLD way. What is the best (and simpliest) way to allow the end users to utilize a frontend for data entry/edit reporting etc. Can I create a link through SharePoint and the user just open it from there.

Your good advise is greatly approciated.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

The proper way, for many years, has been to give each user their own copy of the Access front end database file. And not to share the file among multiple users as this can lead to corruption of the front end file. See the Splitting your app into a front end and back end Tips page for more info. My no longer free Auto FE Updater utility can be used to distribute the Access FE. There are alternative methods mentioned of the bottom of the FAQ page.

Access 2010 now has a web version utilizing SharePoint but it uses data macros. SharePoint is used to store the data as well as the web database file for distribution.

share|improve this answer
    
Great explaination, I'm going to look into upgrading 2010. –  LtDan Jun 23 '11 at 11:51

SharePoint by design will not permit the Access DB to be uploaded. In addition, trying to open it in teh SP site will present issues as it may try and create lock files and such.

share|improve this answer
    
Thanks, that makes sense. –  LtDan Jun 23 '11 at 11:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.