Spaces in Access column names

[boggg1]

Are there restrictions on column names in Access ?. In particular can I use a name with a space in it ?. You will have guessed that the data I want to use already has the column names with spaces. I am using automation to add and retreive data from Access and it isn't working; this is one possible cause.

boggg1

 

[PaulBricker]

It could be. Usually to ensure that field names work regardless of space or not, you wrap the name in square brackets [ignore][field name] or [fieldname] or [field_name][/ignore]. Then there shouldn't be an issue if your fields have spaces in the names. Of course it goes without saying that anytime you can create field names without spaces, that is the preferred method.

Paul

 

[boggg1]

Ok, thanks for the quick reply.

boggg1