I am trying to create a lookup from one Access table to a linked list from SharePoint.   I need to have a lookup between the two because in order to create the type of subform that I need, there has to be a relationship between the two tables.  However, the 'Relationships' button on the ribbon in Access is greyed out.  It seems the problem may be that there is an error every time I open the linked list claiming that 'The setting you entered isn't valid for this property.'  That confuses me a bit, as I haven't actually set any properties- it comes up just from opening the list to view.  I tried creating a new database and linking the table again, but I still get the same error.  I checked the column restrictions in SharePoint, and the only required columns have no blank values, so that shouldn't be it.  There is one calculated column, but it relies only on the required columns.  At this point I have absolutely no idea what is wrong.  Any help would be appreciated.

BTW, there is no custom code running in the database- I've just created the database, created a table, and linked the list.

EDIT:  Some additional information- I have already tried a Compact & Repair, but no luck.  Also, I can reference the UserInfo table from SharePoint without any trouble.

I am trying to reference a SharePoint list from an Access table.  I have linked the list in SharePoint, but when I try to create a lookup column in my Access table, the list is not shown in the lookup selection screen.  I thought this might be because the linked list is throwing an error when it opens, saying 'The setting you entered isn't valid for this property', but now I think that might not be the cause- the table opens after the error is closed, and it contains all the data, all of which is valid.  Is there any other reason this list wouldn't be showing up when I try to create a lookup field?

EDIT: As far as I can tell, Access is only allowing SharePoint linked lists to create lookups on other linked lists, and tables are only able to create lookups to other tables.  How do I get around this?

Hi,

I understand that you want to create a lookup column for an Access table to get information from a linked list from SharePoint. I have a test based on your description and it works as expected. So you need to first fix the 'The setting you entered isn't valid for this property' error. I have seen similar error caused by cache of Access application. You can disable Cache like this:

File>Options>Current Database. Browse down to the bottom and click Never cache.

For more information, please refer to this site:

MS Access Caching Create Error - The setting you entered isn't valid for this property: http://answers.microsoft.com/en-us/office/forum/office_2010-access/ms-access-caching-create-error-the-setting-you/fb9eccbd-9c57-48f7-8243-ab6c20ce1c8f

Thanks,

Entan Ming

Unfortunately, that option is not available (grayed out).  I think this may be because the database is published to SharePoint.  However, when it is selected in test databases, the error does not appear.  This still does not fix the problem though- in my test databases (which do not produce the error), the linked list is not available for a lookup column.

Hi,

I can reproduce your issue: After publishing the database to SharePoint server, you cannot add lookup& relationship column to linked lists. You can only add lookup& relationship to lists that are imported to a new table in current database.

Thanks,

Entan Ming

This doesn't seem to be the issue- after creating a brand new database (not published), linking the Employees list from SharePoint, and disabling the caching as mentioned above, I am still unable to select it when creating a lookup in a new table.