MS Access Database in Sharepoint? 1

[AccessHelp123]

Hi,

I have a MS Access 2007 database that has data relating to the menu items from a different application. There are several tables and queries which are used in forms to display the different menu options that will be available in an application that the team is working on. Team members can view and select the different menu options using the drop downs in forms. Is there a way to integrate this same functionality in Sharepoint using web parts, lists so that access is the backend for the displayed data. Users should also be able to add items in tables using this web interface. Any ideas/suggestions is appreciated.

Regards,
Dan.

 

[dhookom]

I believe you can export your table to sharepoint where it becomes a sharepoint list. You can then link the sharepoint list into your Access application. It should be updateable from both Access and Sharepoint.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

That question sounds like a pure Sharepoint question, but I do not think there is a Sharepoint forum. I find that suprising, because we are leaning more and more on Sharepoint within our company and with our clients. I am running a rather large multi user database with the reverse (backend on sharepoint and front end local). This has been running suprisingly well. There are definately some limits and tricks but it has been pretty stable and provide access from a lot of places. I do not know that much about the Sharepoint side, but I do not believe there is a native feature to do the other way (Sharepoint front end with Access as backend). Same time that sounds self defeating. For sure you can import the menu data from access with no problem into Sharepoint lists. But if that data can be used to manipulate the Sharepoint front end, I have no idea.

Ok, I just walked over and talked to our Sharepoint gurus and they said yes to both. You can link to data sources, and you can use wep apps to read that data and manipulate the display.
If you got more specifics and do not get a answer here, I can see if they can provide details.

 

[SkipVought]

forum820

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MajP]

Oops that is embarassing. And I would think that is the place for the answer.

 

[AccessHelp123]

Thanks for your posts. I was not sure if this was more of an access question or a Sharepoint question. So I posted in both places. I am working with Access 2007 and SharePoint 2007. I am not sure if SharePoint 2007 has the web apps ability.

Regards,
Dan.

 

[dhookom]

I believe only 2010 versions allow the uploading of an Access application (forms, reports, etc) to Sharepoint. This would assume Access Services have been inabled in Sharepoint.

Duane
Hook'D on Access
MS Access MVP