Error when creating make tables

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

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
 
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
'====================================================
 
Back
Top