Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Create connected list from Access Database?

  Asked By: Cara Oliver         Date: Jan 06, 2006      Category: Sharepoint      Views: 675
 

I have an Access Database set up, and I was hoping to publish part of
it as a SharePoint list. I've done this successfully with Excel
spreadsheets and love how it works, but I can't figure out what to do
with Access.

My goal is to use a query to show part of my content in a shared
SharePoint list. I want people to be able to add to this and review it
via SharePoint, and I want to continue synching it with my original
database.

Any thoughts? I've heard I can do this, but I haven't been able to
figure it out.

Tagged:            

 

1 Answer Found

 
Answer #1       Answered By: Harshita Padwal          Answered On: Jan 06, 2006       

Your best option would be to "move" the data to SharePoint. Then, update your MS Access database  to link to the list.

Otherwise, you will need to write synchronization code using the WSS SDK.

 
Didn't find what you were looking for? Find more on Create connected list from Access Database? Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].