Cannot Append Table

[mdg]

When I attempt to append linked tables to my database I get an error message that indicates an INSERT INTO query cannot contain a multi-valued field. The linked tables are identical and should work. Is there a way to append a table that contains multi-value fields? I have spent a lot of time making this database and it would really suck if I can' somehow link the main tables and append/update the data.
Thanks to anyone that knows a work around.

 

[GinaWhipp]

Sorry but not with multi-valued fields (just another reason I don't use them), see...
http://office.microsoft.com/en-us/a...valued-fields-in-queries-HA010149297.aspx#BM7

 

[gemma-the-husky]

i have never even looked at a multi-valued field to see what it does. the trouble is, using special built-in access stuff locks you into access. It is hardly much harder to roll your own "multi-valued" field (ie a simple lookup table) and then you get full transparency and portability, as well as not being limited to just whatever functionality MS decided to give you with the m-v field.

for similar reasons, we rarely bother about defining lookup tables at table level, and ignore the "plus" sign in tables. (is it still there?)

 

[GinaWhipp]

@Dave,

Yep, that little pesky plus sign is still there!