Error 3265

[davehenry]

I get an Error 3265 when trying to update an ADO recordset when I try to copy data into a field name with spaces in it. The same block of code works fine when the field name contains no spaces. I tried putting [ ] and ' ' around the field name, but it hasn't helped. Any ideas?

I don't think you need a quote, [] should be enough.

Thanks for attention

[gknierim]

Personally, I wouldn't use a space in a fieldname. Fieldnames probably can contain spaces, however, good database design refrains from using spaces in fieldnames. :-) They may contain an underscore which is a commonly used substition. Probably depends on the type of database you are using.

Hope this helps a little.

[davehenry]

Thanks! I am going with the underscore.

[gknierim]

You did mean that the name of your fieldname (i.e. Full Name) that had a space in it and not the data that goes in that field right(i.e 'Joe Blow')? Just want to make sure I understood you right.