Access/Sharepoint Integration

[thescott]

Hey all, Can anyone point me toward a book or books that cover integrating
Access with Sharepoint. Basically, I have an Access Database that I would
like to use Sharepoint to display the data. I would like it (Sharepoint) to
be my interface to the data for the client. THX.

 

[John W. Vinson]

Hey all, Can anyone point me toward a book or books that cover integrating
Access with Sharepoint. Basically, I have an Access Database that I would
like to use Sharepoint to display the data. I would like it (Sharepoint) to
be my interface to the data for the client. THX.

What version of Access? It makes a big difference! A2007 has much simpler
Sharepoint integration than previous versions. Such integration would be one
good reason to upgrade.

 

[thescott]

Sorry, I am talking 2003 version of both.

Scott

What version of Access? It makes a big difference! A2007 has much simpler
Sharepoint integration than previous versions. Such integration would be one
good reason to upgrade.

 

[Larry Linson]

Access 2003 VBA, Henning et al, from Wrox/Wiley has good coverage of Access
2003 with SharePoint 2.0. If you have any possibility of arranging it, I'd
second John's advice to move to Access 2007 and SharePoint 3.0 (and I am not
a fan of Access 2007). There have been so many improvements in the
interaction in Access 2007 that overcomes a lot of dislikes in my mind.

If your bookstore has both the book above, and the next edition Access 2007
VBA, also Hennig et al, also from Wrox/Wiley, just browse the sections on
working with SharePoint in both before making a final decision.

Larry Linson
Microsoft Office Access MVP

 

[scubadiver]

Hello,

Have you had much luck?