Tables with reserved names

[Kevin123456]

Hi,

I have an MS Access database with the table name 'All'. When I try to select it in a query (select * from all) then I get a syntax error, presumably 'All' is a reserved keyword. If I rename the table 'Alls' then the select is no problem. Ideally I would like to avoid having to rename the table as following on from this I have two fields in the table called 'Group' and 'Year Group'. When doing an order by 'Group' works with no problems but the field 'Year Group' doesn't sort the data. They are both text fields of 50 characters in length. Is it possible to select from the 'All' table and order by the 'Year Group' field?

Any help gratefully appreciated.

 

[FengShui1998]

Kevin,

I would place Year Group ins square brackets, i.e. [Year Group]. If that doesn't work, then GROUP may be reserved word also.

fengshui_1998

 

[jkl]

AFAIK "All" and "Group" are reserved words in almost all sql databases. Also, it is usually not a good idea to have whitespace in the name of a field.

 

[Kevin123456]

Thanks for the advice, the square brackets worked a treat.