ACCESS MAKE-TABLE QUERY "BUG"(?)

[TWYSTD]

When attempting to run a make-table query, I get the following error message
(please realize that I get the message regardless of whether the target table
exists):
..
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."
..
I am running Office 2003 or Windows XP Professional on a corporate network.
..
Any ideas?

 

[Dirk Goldgar]

When attempting to run a make-table query, I get the following error
message
(please realize that I get the message regardless of whether the target
table
exists):
.
"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data."
.
I am running Office 2003 or Windows XP Professional on a corporate
network.
.
Any ideas?

What is your query's SQL? Does it perhaps involve a memo field, and also
use the DISTINCT keyword?

 

[TWYSTD]

What is your query's SQL? Does it perhaps involve a memo field, and also
use the DISTINCT keyword?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

SQL:
..
SELECT Outage.WORK_ORDER_NBR, Outage.WORK_ORDER_TASK,
Outage.WO_TSK_STATUS_DATE, Outage.SYSTEM_CODE, Outage.DISCIPLINE,
Outage.WO_TSK_STATUS, Outage.[WO-Number] AS [WO-Number],
Outage.WORK_ORDER_TYPE, Outage.WR_TASK_TITLE, Outage.WO_TSK_PLANNER,
[All-current-holds].[Hold Code] AS HOLDS, Ecr.[Ec Request Nbr] AS [ECR #],
Ecr.[Title 195] AS [ECR TITLE], Ecs.[Ec Number] AS [EC#], Ecs.[Ec Status
Desc] AS [EC STATUS], Ecs.[Title 196] AS [EC TITLE], [Current
Comments].[COMMENTS nsed], [Current Comments].[COMMENTS parts], [Parts
hold].MATERIAL_REQUEST, "" AS [Date-PE], * INTO [STATUS UPDATE]
FROM [Current Comments] RIGHT JOIN (Ecr RIGHT JOIN (((Outage LEFT JOIN
[All-current-holds] ON Outage.[WO-Number] = [All-current-holds].[WO Number])
LEFT JOIN Ecs ON Outage.[WO-Number] = Ecs.[WO Number]) LEFT JOIN [Parts hold]
ON Outage.[WO-Number] = [Parts hold].[WO Number]) ON Ecr.[WO Number] =
Outage.[WO-Number]) ON [Current Comments].[WO-Number] = Outage.[WO-Number]
ORDER BY Outage.DISCIPLINE, Outage.WO_TSK_STATUS, Outage.[WO-Number]
WITH OWNERACCESS OPTION;

 

[John Spencer]

Looks like it could be an incorrect error message. It should be complaining
about duplicate fields.

Another possible problem (less likely) is aliasing Outage.[WO-Number] AS
[WO-Number] when you also have [Current Comments].[WO-Number].

SELECT Outage.WORK_ORDER_NBR
, Outage.WORK_ORDER_TASK
, Outage.WO_TSK_STATUS_DATE
, Outage.SYSTEM_CODE
, Outage.DISCIPLINE
, Outage.WO_TSK_STATUS
, Outage.[WO-Number] AS [WO-Number]
, Outage.WORK_ORDER_TYPE
, Outage.WR_TASK_TITLE
, Outage.WO_TSK_PLANNER
, [All-current-holds].[Hold Code] AS HOLDS
, Ecr.[Ec Request Nbr] AS [ECR #]
, Ecr.[Title 195] AS [ECR TITLE]
, Ecs.[Ec Number] AS [EC#]
, Ecs.[Ec Status Desc] AS [EC STATUS]
, Ecs.[Title 196] AS [EC TITLE]
, [Current Comments].[COMMENTS nsed]
, [Current Comments].[COMMENTS parts]
, [Parts hold].MATERIAL_REQUEST
, "" AS [Date-PE]

, * <<<<<<<<<<<<< This (all fields] would create DUPLICATE FIELDS


INTO [STATUS UPDATE]

FROM [Current Comments] RIGHT JOIN (Ecr RIGHT JOIN (((Outage LEFT JOIN
[All-current-holds] ON Outage.[WO-Number] = [All-current-holds].[WO Number])
LEFT JOIN Ecs ON Outage.[WO-Number] = Ecs.[WO Number]) LEFT JOIN [Parts hold]
ON Outage.[WO-Number] = [Parts hold].[WO Number]) ON Ecr.[WO Number] =
Outage.[WO-Number]) ON [Current Comments].[WO-Number] = Outage.[WO-Number]
ORDER BY Outage.DISCIPLINE, Outage.WO_TSK_STATUS, Outage.[WO-Number]
WITH OWNERACCESS OPTION;

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

What is your query's SQL? Does it perhaps involve a memo field, and also
use the DISTINCT keyword?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

SQL:
.
SELECT Outage.WORK_ORDER_NBR, Outage.WORK_ORDER_TASK,
Outage.WO_TSK_STATUS_DATE, Outage.SYSTEM_CODE, Outage.DISCIPLINE,
Outage.WO_TSK_STATUS, Outage.[WO-Number] AS [WO-Number],
Outage.WORK_ORDER_TYPE, Outage.WR_TASK_TITLE, Outage.WO_TSK_PLANNER,
[All-current-holds].[Hold Code] AS HOLDS, Ecr.[Ec Request Nbr] AS [ECR #],
Ecr.[Title 195] AS [ECR TITLE], Ecs.[Ec Number] AS [EC#], Ecs.[Ec Status
Desc] AS [EC STATUS], Ecs.[Title 196] AS [EC TITLE], [Current
Comments].[COMMENTS nsed], [Current Comments].[COMMENTS parts], [Parts
hold].MATERIAL_REQUEST, "" AS [Date-PE], * INTO [STATUS UPDATE]
FROM [Current Comments] RIGHT JOIN (Ecr RIGHT JOIN (((Outage LEFT JOIN
[All-current-holds] ON Outage.[WO-Number] = [All-current-holds].[WO Number])
LEFT JOIN Ecs ON Outage.[WO-Number] = Ecs.[WO Number]) LEFT JOIN [Parts hold]
ON Outage.[WO-Number] = [Parts hold].[WO Number]) ON Ecr.[WO Number] =
Outage.[WO-Number]) ON [Current Comments].[WO-Number] = Outage.[WO-Number]
ORDER BY Outage.DISCIPLINE, Outage.WO_TSK_STATUS, Outage.[WO-Number]
WITH OWNERACCESS OPTION;