Weird Query problem!!!

[99mel]

I've made an append query to append data to a table from another table. When ever I try to run this query it displays that error message:<br>
<br>
---------------------------------------------------------<br>
Run-time error '3078'<br>
<br>
The Microsoft Jet Database engine cannot find the input table or query 'Type11'. Make sure it exists and that its name is spelled correctly<br>
---------------------------------------------------------<br>
<br>
I've been to the SQL and it specifically says 'Type1' not 'Type11' it displays 'Type1' in the SQL but says its got 'Type11', uhhhh<br>
Anyone had this problem before?....All I can think of is a bug/virus that I might have.<br>
<br>
Thanks in advance

 

[Zelandakh]

Can you drop the SQL in here?<br>
<br>
Also what Access are you running? Have you got SP2a?

 

[99mel]

Heres the SQL<br>
<br>
==========================================================<br>
INSERT INTO Type111 ( User, Processor, [Memory/Ram], [Hard-Disk], Modem, Video, Sound, [Net-ID], Serial, TCP, Location )<br>
SELECT Type1.User, Type1.Processor, Type1.[Memory/Ram], Type1.[Hard-Disk], Type1.Modem, Type1.Video, Type1.Sound, Type1.[Net-ID], Type1.Serial, Type1.TCP, Type1.Location<br>
FROM Type1<br>
WHERE (((Type1.User)=[Forms]![4Type1(Edit)]![Text116]));<br>
==========================================================<br>
<br>
I think if I just changed the 'Type1' name to without a 1 it will work, but i'm not really wanting to change the name as I will have to change loads of other code in all my forms to the new table name.

 

[DougP]

If Type111 or what ever is your table name then Access may be getting confused thinking its the Type statement<br>
Try re-naming the table to AType111 see if that works<br>