When using the datagrid with MS Access database and ASP the grid does not support a field if the field name is numeric. I have a table with data where the columns are years, and when DW creates a recordset the values come back fine, but with Datagrid recordset the values for all data in the 1991 column is 1991 etc. Perhaps when using access the field names may need to be wrapped in brackets IE [1991] so that the number is interpreted as a field instead of as a numeric constant. To prove this out I temporarily changed the field to y1991 and it works fine with the alphanumeric name but not with a numeric column name.
Thanks for any help you can provide.

Hello David,

I'll have this added for next update if it is not a big deal of change. Otherwise will need to stall it till the update after next.

Regards,