MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Sync Access and Sharepoint

  Date: Oct 13    Category: MOSS    Views: 1626

I am learning how Access and Sharepoint work together. I can upload an
Access query into a Sharepoint Table, and I can pull data out of Sharepoint into

Now, what if I want to sync two tables?



4 Answers Found

Answer #1    Answered On: Oct 13    

Using SharePoint - you can publish = effectively host the Access d/b within
SharePoint - without having to do a lot of work.

* The database structure - is transformed into SharePoint lists + views, etc

* The data from the database - is stored in a SP - content database (i.e. on SQL

It effectively makes you old Access database - a SQL-server-based database

Pitfall - not everything from your custom Access database design will convert
automatically to a SharePoint hosted Access web application

Here are a couple of useful links

MOSS 2007

SP 2010

Answer #2    Answered On: Oct 13    

Thanks for the info and the links. I read about "moving" an access database to
the sharepoint site. Problem is that I need the database at home, with full
access functionality. It is very large anyway. However, I want to sync certain
bits of information to sharepoint pages.

I can create a linked table in access and create two update queries to update to
and from the sharepoint list. Is there another way such as this, or does anyone
know of a premade access code or addin that will do this?

Answer #3    Answered On: Oct 13    

For your case, the Access Database appears to be

* an external data source (to your SharePoint system)

* so use SharePoint's external data connector functionality

o MOSS - Business Data Catalog

o SP2010 - Business Connectivity Services

Answer #4    Answered On: Oct 13    

No, I am only using wss3............

Didn't find what you were looking for? Find more on Sync Access and Sharepoint Or get search suggestion and latest updates.