Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Sync Access and Sharepoint

  Date: Oct 13    Category: MOSS    Views: 1470

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
Access.

Now, what if I want to sync two tables?

Share: 

 

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
Server)

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

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
office.microsoft.com/.../publish-a-database-to-a-sharepoint\
-site-HA010131469.aspx<http://www.linkedin.com/redirect?url=http%3A%2F%2Foffice%\
2Emicrosoft%2Ecom%2Fen-us%2Faccess-help%2Fpublish-a-database-to-a-sharepoint-sit\
e-HA010131469%2Easpx&urlhash=tc2Z&_t=tracking_disc>

SP 2010
office.microsoft.com/.../build-and-publish-web-databases-RZ\
101874502.aspx<http://www.linkedin.com/redirect?url=http%3A%2F%2Foffice%2Emicros\
oft%2Ecom%2Fen-us%2Faccess-help%2Fbuild-and-publish-web-databases-RZ101874502%2E\
aspx&urlhash=V0Al&_t=tracking_disc>

 
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.




Tagged: