SQL Acting funny for INSERT INTO

I’m working with Visual Basic 6.0 and an Access 2000 Database accessing it through ADODB 2.5 objects (declared in code) and I’m getting some strange behaviour.
When I try to make an Insert Into statement for a specific table I get “Error in Insert Into Statement” message from the ADO object.
If I process a Debug.Print SQL and copy the output and run the exact same SQL in Access it works fine. Also any other Insert statements I’ve writen do work fine (all for other tables tho.)

Thanks In Advance
Shawn