Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a MS Access 2007 database and a WSS 3.0 site (neither of which I am very experienced in). The database is currently stored on a shared drive with users remoting in to work with it. In an effort to improve usability and performance, I want to host this db on my WSS 3.0 site. Is this feasible? I need to be able to access and edit data using forms, as well as run reports, all through the UI of the sharepoint site.

share|improve this question
add comment

2 Answers

Also, remember that you must create a *.accde, rather than leave it as accdb. The accde is somewhat compiled (queries and code modules are hidden), and the only thing users can manipulate is the actual data. They cannot edit forms/reports/etc.

accdb is the standard filetype, and accde is created via the Database Tools ribbon. accdb is one of the default restricted file extensions in Central Admin. You can change it if you want, but personally I wouldn't.

share|improve this answer
add comment

You can certainly store your Access databases in your WSS 3.0 site. But users will still need their own copy of Access to open the database.

Also note that even in SharePoint 2010 Access Services will allow users to open databases, but they still need the Access client software to modify them.

share|improve this answer
add comment

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.