>Good afternoon, right now I'm writing an app in MS Access that connects to SQL Server through ODBC.
>
>The problem that I'm having is when I retrieve the data from a datetime field, it's always 1 hour back in Access.
>
>Honestly I've think that the problem is related to some kind of config in the odbc driver setup, but I can't find the way to solve it.
>
>Thanks in advance for yout help.
>
>Melvin
Does your server and your local computer show the same date and time? In other words, when you do select getdate() from SQL Server, is it the same as your local time?
If it's not broken, fix it until it is.
My Blog