Reserved error (-3002); there is no message for this error

S

Stapes

Hi

This is what I am trying to do:

INSERT INTO TTEMP_CampaignRun05 SELECT TM_CompContact.FK_CompID,
TM_CompContact.PK_Contact, TM_CompContact.Group,
TM_CompContact.SubGroup, TM_CompContact.LCO, TM_CompContact.Source,
TM_CompContact.AcNo INTO TTEMP_CampaignRun05 FROM TM_CompContact INNER
JOIN TTEMP_CampaignRun03 ON TM_CompContact.FK_CompID =
TTEMP_CampaignRun03.FK_CompID WHERE (((TM_CompContact.Offer)= 410));

And this is ther error message:


Run-time error '3000':

Reserved error (-3002); there is no message for this error

Any ideas?

Stapes
 
G

Guest

Anything strange happen when you run the following:

SELECT TM_CompContact.FK_CompID,
TM_CompContact.PK_Contact,
TM_CompContact.Group,
TM_CompContact.SubGroup,
TM_CompContact.LCO,
TM_CompContact.Source,
TM_CompContact.AcNo
FROM TM_CompContact INNER JOIN TTEMP_CampaignRun03 ON
TM_CompContact.FK_CompID = TTEMP_CampaignRun03.FK_CompID
WHERE TM_CompContact.Offer= 410 ;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the difference between these two stATEMENTS 2
Complex query with Union Query in process runs for ever 2
error: 3061 - Too few parameters 1
Works in query, but not in VBA 1
No unique index found for the referenced field of the primary table. (Error 3609) 7
Reserved error (-1524); there is no message for this error. 3
Reserved Error (-7776) there us no error message for this error 1
"Reserved Error (-1517) - there is no messsage for this error" mes 1

Top