Re: Upsizing to SQL 2000 backend (Access2000)

Reply

Access datatypes don’t always have an exact equivalent in SQL Server. The date/time fields are perhaps the worst case of that, since Access doesn’t understand SQL Server datestime stamps and vice versa. Don’t try to force them to use the “same” field type because it won’t work. If you upsized the table, the date fields would have been converted from normal Access format datetimes to a SQL Server date/time field. Then in views, you would have to convert the value back to a date/time that Access could work with.

Quote