If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error when creating make tables
I have been using the same make table queries for months and when I ran two
different queries yesterday, I am receiving errors on both queries after the existing tables were deleted, but as the new table is being created. The error reads as follows "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." Can you please tell me what the issue is? How can I identify the guilty field(s)? Thanks |
#2
|
|||
|
|||
Error when creating make tables
Drop one field at a time from the make table query until you don't get
the error. That should identify the field that is causing the problem. Once you have identified the field with the problem, you can look at its data and try to determine the cause of the problem. '================================================= === John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County '================================================= === fgwiii wrote: I have been using the same make table queries for months and when I ran two different queries yesterday, I am receiving errors on both queries after the existing tables were deleted, but as the new table is being created. The error reads as follows "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." Can you please tell me what the issue is? How can I identify the guilty field(s)? Thanks |
Thread Tools | |
Display Modes | |
|
|