So I have a custom list in SharePoint 2010 with 10 or so columns. I then link the list within MS Access 2007. Works just fine until I try adding a look-up or people-type column to the list, then the next time I refresh the MS Access table link I get the following message:

Error: "The Microsoft datbase engine cannot find the object 'TMP%开发者_开发问答.MAU@'. Make sure the object exists..." blah, blah, blah

Then of course, the data is inaccessible through MS Access after that point. If I then go back to SharePoint and delete the new column, it starts working again in MS Access.

I can add any other kind of columns, and it works fine.

What gives? Is there s limit to the number of people columns you can have in an MS Access linked SharePoint List?

========

New Information

So I deleted all of the data from the sharepoint list, and the error went away, no matter how many people columns I added. But as soon as you add a single record back in, the error returns... :(

---

Found the solution.

The error stems from a "hidden" threshold limit set within SharePoint Central Administration that limits the number of lookup columns returned within a given query. This means linked MS Access lists to SharePoint would be limited as well, hence the error. The problem is MS Access 2007 doesn't give you a nice error message to explain this to you, whereas SharePoint 2010 does.

The fix is simple--just bump up the threshold and you're good to go. Here is how: enter link description here

---

This does work in Access 2010.

I suspect you need thus Access 2010 use such a multi-value type of column. While 2007 does support SharePoint, I thinking this is a new type of column in SharePoint.

When you say you are adding a people type, then I assume you are choosing "Person or Group" as a SharePoint type. You are then setting this column as multiple choice.

This does work just fine for me in Access 2010. Even in table edit view from the Access side I get the multi-choice pick list, so I am thinking this is an Access 2007 limitation. Note that I do NOT need delete + re-link to see the changes after I add the new column. I did however right click on the table in Access, then choose more options, and then then refresh list. I get this view inside of access when I use that column:

I also find I can add new columns from inside of Access to this linked table if you use the table tab on the ribbon. The people picker is not a legal type from the choices in Access, but adding from SharePoint does work for me.

The only thing I might be doing different from you is the table was originally created and uploaded from Access.