Hi All,
I am building an access DB with 3 tables. I need to be able to link the tables to the sharepoint site and users should be able to use DB form to update records in sharepoint.
In the beginning, i was planing on creating one table for all fields but then I realized that I would have to create relationships with multiple tables.
We have Sharepoint 2010 and I read somewhere, that Sharepoint 2010 does not support relationships tables but I am not sure if this is accurate because of the following:
I created the three tables, created a blank form, included a couple of fields from table 1. I then added a subform, added a couple of fields from table 2, created another subform from table 3, added a couple of fields....while I was adding fields on subforms the wizard was promoting me how i wanted certain fields to be linked. At the end, i noticed that the relationships were automatically created. I then linked the tables to sharepoint and it appeared to be working fine.
Now the questions:
1. Am i on the right track? Does Sharepoint 2010 in fact support related tables?
2. I tried creating queries/reports but when I run them I get an error that says "The wizard was unable to open your form ... query in form view or datasheet view, possibly because another user has a source table open in exclusive mode."
I checked the data type and everything seems to be fine - as per proposed solutions on this site.
Is this perhaps because of Sharepoint 2010?
Thank you
I am building an access DB with 3 tables. I need to be able to link the tables to the sharepoint site and users should be able to use DB form to update records in sharepoint.
In the beginning, i was planing on creating one table for all fields but then I realized that I would have to create relationships with multiple tables.
We have Sharepoint 2010 and I read somewhere, that Sharepoint 2010 does not support relationships tables but I am not sure if this is accurate because of the following:
I created the three tables, created a blank form, included a couple of fields from table 1. I then added a subform, added a couple of fields from table 2, created another subform from table 3, added a couple of fields....while I was adding fields on subforms the wizard was promoting me how i wanted certain fields to be linked. At the end, i noticed that the relationships were automatically created. I then linked the tables to sharepoint and it appeared to be working fine.
Now the questions:
1. Am i on the right track? Does Sharepoint 2010 in fact support related tables?
2. I tried creating queries/reports but when I run them I get an error that says "The wizard was unable to open your form ... query in form view or datasheet view, possibly because another user has a source table open in exclusive mode."
I checked the data type and everything seems to be fine - as per proposed solutions on this site.
Is this perhaps because of Sharepoint 2010?
Thank you
