Using Access 2003 with SharePoint 2003

Although SharePoint 2003 uses SQL Server database technology to store its information (MSDE is a limited version of SQL Server), Access 2003 can add value when used with SharePoint 2003 and may be better suited to storing certain types of data because many organizations have support personnel who are experienced with Access databases and find them easier to work with than the SharePoint SQL databases.

Access can also be used to store information exported from SharePoint 2003 lists, as well as to store forms information, which can assist with backup and storage requirements. Access's ease of use and flexibility, combined with its web form design tools make it the ideal choice. Access 2003 also allows for ...

Get Microsoft® SharePoint™ 2003 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.