asked on

Add new record to a linked SharePoint table

I have an Access 2007 db linked to sharepoint tables. I need to add a new record to the SharePoint table using an Access form. The form is created from the table. I open the form in add record mode and the user inputs all data. All inputs work fine except two multiselect combo boxs.

I am using the .addnew agruement in the beginning then setting each field in the recordset equal to the values in my controls with a .update at the end of my procedure. The record is not saving. I get an error of data mismatch. The combo boxes are bound to an ID column.

Also if I try to save without these two controls, i get a "table schema has changed" error.

I am sure there is an easy solution but this SharePoint table is 26K records and slow so my patience is dwindling.

Thank you in advance.

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kkniemeier

ASKER

fyed,

Thanks for the response.

The value returned is numeric but unsure of whether it is concatenated . I will try to get you the code on Monday. The field in the linked table is set up as a long integer. I tried doing a convert but that did not work (maybe i did it wrong). I am a little rusty with my code since i have not used the skill for a few years. I know very little about SharePoint but am learning rapidly.

Thanks.

kkniemeier

ASKER

Fyed responded and was helpful in confirming the issue. I was able to solve the problem without further discussion. The answer was good but due to restrictions on what information i could share, I was not able to provide him more info for a more thorough answer. Fyed deserves the points for responding.