Can tacbles in access Start with a number

[Mr Oizo]

Hi i am trying to find out if tables and fieldnames can start with a number in access. I am writing my Select command for my adapter and I keep getting an error sayig there is a missing operator. My sql is pasted below: Dim value As String = DateTimePicker1.Value.Date.ToString modbcmdSelect.CommandText = ("SELECT * FROM dayScheduleTemplate,dayTemplateScheduleName, scheduleDate " & _ "WHERE dayScheduleTemplate.dayTemplateScheduleName = dayTemplateScheduleName.24TemplateScheduleName and " & _ "dayTemplateScheduleName.24TemplateScheduleName = scheduleDate.24TemplateScheduleName and scheduleDate.scheduleDate= #" & value & "#") Mr oizo

[Guffa]

Put brackets around the field name: dayTemplateScheduleName.[24TemplateScheduleName]

--- single minded; short sighted; long gone;

[Dave Kreskowiak]

If possible, you'd probably have to enclose any such table and field names in square brackets:

SELECT * FROM dayScheduleTemplate,dayTemplateScheduleName, scheduleDate
WHERE dayScheduleTemplate.dayTemplateScheduleName = dayTemplateScheduleName**.[24TemplateScheduleName]**
and dayTemplateScheduleName**.[24TemplateScheduleName]** = scheduleDate.[24TemplateScheduleName] and
scheduleDate.scheduleDate

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007