General information
Category:
Database DAO/RDO/ODBC/ADO
>First of all, thank you for your assistance. I truly appreciate it!
>
>I've narrowed the problem down to be the space in the field name. If I test my query in the Visual Data manager it works fine with the [Contract #] field name. In VB it works if I change the field name for testing - I cannot change the field name permanently!
>
>In VB though, it will not work for me with the space in the field name. Is there some way around this apparent bug? This field name is no trouble for other queries but it is obviously causing issues with the INSERT.
>
>Any thoughts for me to try?
>
>Thanks again,
>John
See if you can add it through ADO with the AddNew method of the recordset.
As a Hail Mary :), try specifying the fully qualified field name (with table and all) in the insert statement like so: [method2].[contract #]
Other than that I am all out of ideas.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only