By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Moving Access 2010 tables to SharePoint

P: 1
I am trying to move my Access2010 database to SharePoint. My database tracks project and because more than one person can work on a project and a person can work on multiple projects, I have a ProjectPerson table that essentially as a ProjectID field and a PersonID field. When I try to send it to SharePoint, I am being told that table ProjectPerson is dependent on table Project which is not allowed in SharePoint. Hwo do I set up my tables to get around this?

Thanks
Apr 12 '12 #1
Share this Question
Share on Google+
1 Reply


Narender Sagar
100+
P: 189
You can try with first exporting your 'table project' to sharepoint, and it will automatically export table ProjectPerson (if it is dependent on table project). Otherwise you can remove relationships first and then export the tables as Lists in Sharepoint. Then link those lists back in your access database. Then again build the relationships.
HTH
Pl. let me know, if this helps.
Apr 17 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.