Make table query with a photo attached

[mose Mbugua]

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.

[twinnyfo]

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.

[mose Mbugua]

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.

[twinnyfo]

Instead of an attachment field, just have a text field. The entries will be the location of the photo you want displayed:

"C:\User\UserName\Pictures\Eiffel Tower.jpg"

Of course, if your DB will be used in a network situation, you must make sure your photos are on a shared, available network location.

[zmbd]

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.

[mose Mbugua]

Zmbd:
i used a select query and it worked for me.

[twinnyfo]

mose,

So, did you find resolution to your problem?

[mose Mbugua]

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.

[mose Mbugua]

twinnyfo
i used your idea but the reply was an error message (#name). I can be a good student if you show me how!!

[zmbd]

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.