Hi,
First of all, let me put you on context. I have 2 SharePoints: The Master SharePoint from whom I can only read data, and an owned SharePoint into which I have total control. What I have to do, is to read some entries from a list on the Master SP with an Access database, process it some how and then write the results on a list on my owned SP. Both SharePoints are 2010 and I also use Access 2010.
OK, so all that is easy to do. I just link both tables on my Access Database, SELECT from the master, process and INSERT into the owned table. The issue is that one of the fields from the master list is of People/Group type but in the linked table definition in Access, it is shown as number type, although if I look for the data on that field, it is pure text. So when I try to write that value into my other table it gets written as a number.
In summary, Master SP field is defined as people/group but shown as number in access. Owned SP field MUST be defined as text, but it brings a numeric value from the master list.
Any thoughts on how to fix this?
Thanks in advance!
Vic
First of all, let me put you on context. I have 2 SharePoints: The Master SharePoint from whom I can only read data, and an owned SharePoint into which I have total control. What I have to do, is to read some entries from a list on the Master SP with an Access database, process it some how and then write the results on a list on my owned SP. Both SharePoints are 2010 and I also use Access 2010.
OK, so all that is easy to do. I just link both tables on my Access Database, SELECT from the master, process and INSERT into the owned table. The issue is that one of the fields from the master list is of People/Group type but in the linked table definition in Access, it is shown as number type, although if I look for the data on that field, it is pure text. So when I try to write that value into my other table it gets written as a number.
In summary, Master SP field is defined as people/group but shown as number in access. Owned SP field MUST be defined as text, but it brings a numeric value from the master list.
Any thoughts on how to fix this?
Thanks in advance!
Vic
