Am trying to design a make table query from a table which has a photo attached to it. when i click on the run icon, an error message reading "Multi-valued fields are not allowed in SELECT INTO statements". what could be the casuse and how do i solve that? Thanks.
Make table query with a photo attached
Collapse
X
-
Tags: None
-
As far as I know, when you have a table with attachments, you cannot perform the same actions you can with normal data. In stead of attaching the photo, have you tried using a text string which identifies a path and file name? This would also save on db size. -
Hi twinnyfo, i dont know how to do that. i'm a student and don't know how to use a text string to identify the file name.
am sure you can help on that.Comment
-
Instead of an attachment field, just have a text field. The entries will be the location of the photo you want displayed:
Code:"C:\User\UserName\Pictures\Eiffel Tower.jpg"
Comment
-
mose Mbugua:
You also need to consider, why is it that you need a make table query?
Although there are certainly times where this is needed, I have personally found that such needs tend to indicate that the underlying table structure, the database schema, has serious flaws in the design and in need of normalization.Comment
-
-
i did. For now. until i find out another easier way to solve that. i ran a select query then used report wizard to display the info.. Thanks for your help.Comment
-
twinnyfo
i used your idea but the reply was an error message (#name). I can be a good student if you show me how!!Comment
-
Before we can really help you any further, we'll need to have a better understanding of what you are currently working with; therefor, please show us your work.
Please, NO attachments at this stage, besides, many of our experts/moderators are unable to open them from where we normally answer the questions.
All script (VBA, SQL, etc...) and formatted text (tables) should be enclosed in between [CODE] [/CODE] tags - click on the [CODE/] button in the post toolbar and then cut and paste your script between the [CODE] [/CODE] tags.Comment
Comment