• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

15. Office Web and SharePoint > 15.2. Create a SharePoint Data View Web Part Ba...

15.2. Create a SharePoint Data View Web Part Based on Access Data

Problem

FrontPage 2003 makes it easy to extend SharePoint sites to include data from databases, web services, XML documents, and other sources and display that data using the Data View Web Part. You can easily link to SQL Server data and display that within a Data View Web Part but it’s not clear how you link to data in an Access database. Is this possible?

Solution

Tip

This solution requires FrontPage 2003 and a web server running Windows SharePoint Services.

It’s not totally obvious, but by hand-coding an OLEDB connection string you can create a Data View Web Part based on an Access database connection.

To create an Access database connection, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint