Home > IT Answers > Microsoft Windows > Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.
Domc111
5 pts.
 Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.
Access 2007, Access query, Microsoft Access, SharePoint, SharePoint 2007
Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to link the pre-existing query in Access to Sharepoint without having to copy it first - the aim being any changes to the pre-existing Access query are reflected in Sharepoint

Software/Hardware used:
ASKED: March 11, 2009  3:18 PM
UPDATED: March 13, 2009  2:15 AM
RELATED QUESTIONS
Answer Wiki:
Hmmm… I have done this with Access 2007 on Share Point 2003 without any problem. Can not think why it will not work on Sharepoint 2007. May be access privilege issue. Is the Access database getting updated on SharePoint? Can you link the Table/query on SharePoint server?
Last Wiki Answer Submitted:  March 13, 2009  2:15 am  by  SbElectric   2,510 pts.
All Answer Wiki Contributors:  SbElectric   2,510 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _