D
Dale Fye
I've got a backup routine that copies all of the data from the sharepoint
lists attached to my application into tables in an accdb file. This routine
generates and executes a series of MakeTable queries that select all of the
fields from all of the records in each of these linked lists.
Because these tables are SharePoint lists, they all come with the baggage of
several fields that I have no control over, one of which is an "Attachments"
field, which appears to be a multi-valued field, but which does not contain
any information in any of my lists.
Up until yesterday, my code executed properly, copying all of the tables
(including the Attachments field) with no problems. Then I added a new table
(which contains no information in that field). Now, when I run my MakeTable
query:
SELECT [tbl_User_Log].*
INTO [tbl_User_Log]
IN "C:\Users\xxx\Documents\Work\Backups\Backup_2009-12-09-0928.accdb"
FROM [tbl_User_Log]
I encounter error #3838 Multi-valued fields are not allowed in Select INTO
statements.
This is the 2nd to last table in the routine, and every other table
containing this field is inserted properly into the destination accdb.
I know I can modify my code so that it loops through the fields and builds a
SQL string that enumerates each field (leaving out the Attachments) field, so
that is obviously a possible solution. But I would prefer to figure out what
has changed and why this table is being treated differently than all of the
other tables.
lists attached to my application into tables in an accdb file. This routine
generates and executes a series of MakeTable queries that select all of the
fields from all of the records in each of these linked lists.
Because these tables are SharePoint lists, they all come with the baggage of
several fields that I have no control over, one of which is an "Attachments"
field, which appears to be a multi-valued field, but which does not contain
any information in any of my lists.
Up until yesterday, my code executed properly, copying all of the tables
(including the Attachments field) with no problems. Then I added a new table
(which contains no information in that field). Now, when I run my MakeTable
query:
SELECT [tbl_User_Log].*
INTO [tbl_User_Log]
IN "C:\Users\xxx\Documents\Work\Backups\Backup_2009-12-09-0928.accdb"
FROM [tbl_User_Log]
I encounter error #3838 Multi-valued fields are not allowed in Select INTO
statements.
This is the 2nd to last table in the routine, and every other table
containing this field is inserted properly into the destination accdb.
I know I can modify my code so that it loops through the fields and builds a
SQL string that enumerates each field (leaving out the Attachments) field, so
that is obviously a possible solution. But I would prefer to figure out what
has changed and why this table is being treated differently than all of the
other tables.