Query Runs For Awhile, Then Pops "Invalid Argument"?

P

(PeteCresswell)

This query runs for about 7 seconds, then pops an error dialog:
"Invalid Argument"

What's got me stumped is how long it runs. Typically when I
mess something up it gets caught on the syntax scan or it bombs
almost immediately after starting to run.

Visual representation at:
http://www.flickr.com/photo_zoom.gne?id=493642965&size=o


SQL for the main ("...Moody2") Query:
--------------------------------------
PARAMETERS theUserID Text ( 255 ), theTimeStamp DateTime;
INSERT INTO tblAnalytics_IndustryExposure ( DealID, AsOfDate,
IndustryNameID, IndustryPercent, CreatedAt, CreatedBy )
SELECT ttblAnalytics_Deals.DealID, ttblAnalytics_Deals.AsOfDate,
qryAnalytics_AppendMainTables_IndustryExposure_Moody1.IndustryNameID,
ttblAnalytics_IndustryExposureMoody.IndustryPercent,
[theTimeStamp] AS Expr1, [theUserID] AS Expr2
FROM (ttblAnalytics_IndustryExposureMoody INNER JOIN
ttblAnalytics_Deals ON
ttblAnalytics_IndustryExposureMoody.DealName =
ttblAnalytics_Deals.DealName) INNER JOIN
qryAnalytics_AppendMainTables_IndustryExposure_Moody1 ON
ttblAnalytics_IndustryExposureMoody.IndustryName =
qryAnalytics_AppendMainTables_IndustryExposure_Moody1.IndustryName;
--------------------------------------

SQL for the "...Moody1" query:
---------------------------------------
SELECT tlkpAnalytics_IndustryName.IndustryNameID,
tlkpAnalytics_IndustryName.IndustryName,
tlkpAnalytics_IndustryName.SupplierID
FROM tlkpAnalytics_IndustryName
WHERE (((tlkpAnalytics_IndustryName.SupplierID)=1))
ORDER BY tlkpAnalytics_IndustryName.IndustryName;
 
R

RogerManiccia@ebs

Peter,

Sometimes when this has happen to me, I first thing I check is the size of
the database. MS Access has a 2GIG size limitation. Even if the issue is
not the size limitation, I would be inclined to compact and repair the
database.
 
I

IRS Intern

SORRY; THIS SIZE LIMIT IS ONLY PRESENT IN MDB; THIS IS NOT A
LIMITATION IN MDB




Peter,

Sometimes when this has happen to me, I first thing I check is the size of
the database. MS Access has a 2GIG size limitation. Even if the issue is
not the size limitation, I would be inclined to compact and repair the
database.
--
Roger Maniccia
emdeon
615-886-9031



(PeteCresswell) said:
This query runs for about 7 seconds, then pops an error dialog:
"Invalid Argument"
Click to expand...
What's got me stumped is how long it runs. Typically when I
mess something up it gets caught on the syntax scan or it bombs
almost immediately after starting to run.
Click to expand...
Visual representation at:
http://www.flickr.com/photo_zoom.gne?id=493642965&size=o
Click to expand...
SQL for the main ("...Moody2") Query:
--------------------------------------
PARAMETERS theUserID Text ( 255 ), theTimeStamp DateTime;
INSERT INTO tblAnalytics_IndustryExposure ( DealID, AsOfDate,
IndustryNameID, IndustryPercent, CreatedAt, CreatedBy )
SELECT ttblAnalytics_Deals.DealID, ttblAnalytics_Deals.AsOfDate,
qryAnalytics_AppendMainTables_IndustryExposure_Moody1.IndustryNameID,
ttblAnalytics_IndustryExposureMoody.IndustryPercent,
[theTimeStamp] AS Expr1, [theUserID] AS Expr2
FROM (ttblAnalytics_IndustryExposureMoody INNER JOIN
ttblAnalytics_Deals ON
ttblAnalytics_IndustryExposureMoody.DealName =
ttblAnalytics_Deals.DealName) INNER JOIN
qryAnalytics_AppendMainTables_IndustryExposure_Moody1 ON
ttblAnalytics_IndustryExposureMoody.IndustryName =
qryAnalytics_AppendMainTables_IndustryExposure_Moody1.IndustryName;
--------------------------------------
Click to expand...
SQL for the "...Moody1" query:
---------------------------------------
SELECT tlkpAnalytics_IndustryName.IndustryNameID,
tlkpAnalytics_IndustryName.IndustryName,
tlkpAnalytics_IndustryName.SupplierID
FROM tlkpAnalytics_IndustryName
WHERE (((tlkpAnalytics_IndustryName.SupplierID)=1))
ORDER BY tlkpAnalytics_IndustryName.IndustryName;
Click to expand...

- Show quoted text -
Click to expand...
 
Top