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.
9 1490
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.
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 5,501
Expert Mod 4TB
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.
Zmbd:
i used a select query and it worked for me.
mose,
So, did you find resolution to your problem?
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.
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 5,501
Expert Mod 4TB
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: PMB |
last post by:
Thank you in advance for any and all assistance.
I'm trying to use a make table query to pull the last transactionID, so I
can use an append query to reset the transactionID to the next...
|
by: Oreo Bomb |
last post by:
I have a secured database that contains a Read-Only group. This group
has permissions to view reports, but cannot add, edit, or delete any
DB objects. One of the reports the group needs access to...
|
by: Kathy Krizl |
last post by:
I'm probably doing something stupid, but I have a make table query.
One of the tables I reference has some check box fields in it. Their
Data Type is Yes/No, their field property format is Yes/No,...
|
by: Dragon |
last post by:
When I run a make-table query, the results take over 1 minute to
return. The query is making a table that has 12,000 records in it.
If I run the make-table query ONLY to see the records that will...
|
by: Hanif Merali |
last post by:
Hello,
I'm having some difficulties creating a make table query. The source
table which I'm basing the make table query has the fields:
CIF
BusLine1-2001
BusLine1-2002
BusLine1-2003...
|
by: Doc |
last post by:
Per earlier post, I am trying to save 'out' production data from a
program called Solomon - basically (I think) this was /is an Access/Sql
based program.
We are updating to different application...
|
by: danijela.simunovic |
last post by:
Hi!
Is there a way that when I run a "make table query" and an "append
query" that i won't be asked those 2 or 3 questions from access like
:"you are about to run a make table...","the existing...
|
by: ken |
last post by:
Hi,
I use this command to run a make table query without opening it...
CurrentDb.Execute "make table query name"
Access tells me that it can't execute a select query...? Its a make
table query...
|
by: Robertf987 |
last post by:
Hi, I'm a bit stuck with an access database. I'm using access 2000 if that's any help.
Right, it's 3:40am right now and I'm rather tired, but I *hope* this makes sense.
I have a table which...
|
by: ALaurie10 |
last post by:
I keep getting the "in use by another user or process" error.
Is there some way to lock the table temporary.
I want a user to click a command button on a form that runs a Macro that opens a...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |