Forum Discussion
Append query
Sorry., my original reply didn't appear so the above comment made little sense.
Multivalued fields (MVFs) are in many ways a poor choice and most experienced developers will recommend avoiding their use. See my article http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763.
The issue is that they depend on a deep hidden system table over which you have no control.
The error message is clear. MVFs cannot be used in INSERT (append) queries. This is the result of the deep hidden table. There is no simple work round. You will also be unable to use MVFs in make table or delete queries...though update queries can be done.
Recommend you replace all MVFs with standard fields, one value per record. You will find life becomes far easier
- Hi.
Attachment fields are a special type of MVF. They have all the disadvantages of MVF fields and massively bloat the database size. Again much better to avoid them completely.
Whilst I can do remote sessions, I cannot do so this week. What purpose would a remote session have for your problem?- I still need your help. I tried setting up several attachment fields on place of the one multivalued field. It did not seem to work. These attachments are very important to what I am doing.
Will you be available to do a remote session this upcoming week?As already explained, attachment fields are a special type of MVF and should be avoided as well.
I never use either of those datatypes in Access and am unable to assist with making these work for you.
Instead of attachment fields, store the files outside Access and use a text field to store the file paths in Access.