J
jhcoxx
I'm trying to help make it easy for our end-users to use SharePoint and
Access together. By using the techniques in
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnsmart03/html/sa03i1.asp
I've been able to programmatically link a table in Access to a
SharePoint list - but that's not exactly what's needed. The problem
is that an Access table linked to a List has no field set as a
Primary Key. There is an ID field that is added to a custom list that
is
an AutoNumber field, but not a Primary Key. Because the Access table
is linked, users can't go into the Access table's Design Mode and set
that - and have the changes saved.
I had hoped that creating an Access table with the same fields as the
List, except with the ID field already set as a Primary Key - and
then linking the two - would do the trick, but it's not working.
Linking to
a List seems to always generate a new table - the new table's name is
the same as the one specified, but with a numeric suffix added.
Anyone have any idea how to manually (or better, programmatically)
edit the properties of a field in a linked Access table?
Or for that matter, any insights into how to get SharePoint to make a
linked Access table have the ID field be a Primary Key?
Thanks in advance for any help on this!
James
Access together. By using the techniques in
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnsmart03/html/sa03i1.asp
I've been able to programmatically link a table in Access to a
SharePoint list - but that's not exactly what's needed. The problem
is that an Access table linked to a List has no field set as a
Primary Key. There is an ID field that is added to a custom list that
is
an AutoNumber field, but not a Primary Key. Because the Access table
is linked, users can't go into the Access table's Design Mode and set
that - and have the changes saved.
I had hoped that creating an Access table with the same fields as the
List, except with the ID field already set as a Primary Key - and
then linking the two - would do the trick, but it's not working.
Linking to
a List seems to always generate a new table - the new table's name is
the same as the one specified, but with a numeric suffix added.
Anyone have any idea how to manually (or better, programmatically)
edit the properties of a field in a linked Access table?
Or for that matter, any insights into how to get SharePoint to make a
linked Access table have the ID field be a Primary Key?
Thanks in advance for any help on this!
James