asked on

Access 2010/ sharepoint help..

I working on adding a filter to a exsisting report in Access 2010 in a Sharepoint enviornment. Whats the best way to go about adding this feature, since im under the impression sharepoint does not support code modifications.

ASKER CERTIFIED SOLUTION

Richard Daneke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IT_newbie01

ASKER

or you can use Access 2010 to create a web-based Access environment to filter without having Access installed on each users' workstation.

This is exactly the option i want to employ. Do you have an example of how to do this??

Richard Daneke

You can create a web database from a template.
Here is an MS link:
http://office2010.microsoft.com/en-us/access-help/publishing-to-access-services-HA101862691.aspx

How well do you know your sharepoint environment? Access Web services have been available in the Sharepoint environment in 3.0, 2007 and 2010. Which Sharepoint environment are you using? Office365 Sharepoint includes the Access Web services.

IT_newbie01

ASKER

I'm using Access 2010 (from what i read Office 365 is just another name for this suite) and i know very little about the sharepoint enviornment. I'm familiar with Access 03 but see 2010 has changed considerably! Not to sound like a noob but i was looking for picture and heavy descriptive documentation.

aikimark

Access2010 and Office365 are two different animals

IT_newbie01

ASKER

Maybe this should be a new question: What's the best to publishing an Access report to the web that's filterable (drop-down list)??? I'm reading alot that suggest a lookup table. Is creating a drop-down list even possible when dealing with Access Web services???

THANKS IN ADVANCE!!!

IT_newbie01

ASKER

Ok, apologies i misread. I'm using sharepoint 365.

Richard Daneke

You should open a web template in Access 2010 and see if you can publish the sample database to your SharePoint site. If you have Office365, the sharepoint includes Access Web services.

Since you have Office2010, another option is to save your list as an Excel table with autofilters. This would permit your users to filter as necessary.

IT_newbie01

ASKER

Ok, I actually only have Access 2010. Are you suggesting not attempting to use Access/ Access Web services to create a filterable table???? But suggest using Excel table with auto-filters?? If so why?? What would be the disadvantages/ advantage??