Web Application Using Microsoft Access 2007 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.

 

[ehaze]

Assume you are talking about SharePoint 2007?

You could sync a SharePoint List with an Access table. Don't think you would want Access to be a data source for SharePoint.

Filtered Web Parts:

http://office.microsoft.com/en-us/sharepoint-server-help/work-with-filter-web-parts-HA010033786.aspx

Using SharePoint Designer, you can do more custom stuff with the Data View Web part. Parent-child relationships, filtering data, ...

If you wanting to work more with forms, take a look at InfoPath.

http://www.sharepointed.com/

 

[AccessHelp123]

Thanks ehaze. The problem I have is I am running a lot of queries in Access. The queries are used by the forms. There are several drop down lists in the form. Based on what is selected in one drop down list the corresponding items change in the next drop down list. I am not sure how this can be replicated in SharePoint 2007.

Can I create forms in Sharepoint designer that behave similary (or even access the database directly) or do I need to use infopath.

Regards,
Dan.

 

[ehaze]

Think of InfoPath forms, like forms you would create in Access.
Look on youtube or google for some quick demos / examples.

Yes, InfoPath can pull data from many different data sources.

InfoPath info:

http://office.microsoft.com/en-us/i...crosoft-office-infopath-2007-HA010163577.aspx

SharePoint Designer is a tool like FrontPage, but with more features. It allows you to interact with SharePoint without having to open Visual Studio.

Linking to Access from Designer:

http://www.kmo.name/sharepoint/spdesigner2007_access.pdf

SharePoint Designer info:

http://office.microsoft.com/en-us/sharepoint-designer-help/CH010220127.aspx

Let me know if you have more questions.

http://www.sharepointed.com/

 

[AccessHelp123]

This looks very promising. I will try this today and see how it goes. Thanks.