syntax error

[elnashar77]

I created a SQL in a program where I access an ACCESS file and its fields. The file name does not have any embedded spaces. My question is that I would like to change the file name to have some spaces in the name. I get a syntax error. Has anyone faced this problem and come up with a fix to it?

Thanks for the help.

AN

[Killer42]

I created a SQL in a program where I access an ACCESS file and its fields. The file name does not have any embedded spaces. My question is that I would like to change the file name to have some spaces in the name. I get a syntax error.

Perhaps you could show us the code in question. I didn't think SQL used filenames at all.

Are you sure you don't mean a table name? If so, put [square brackets] around around the name.