Problem with time ACC XP/SQL Server

[D. UTEAU]

Hello

I have developed an ADP project under Access 2000 that I
now use under Office XP. The database I finally work with
is a SQL Server 2000 database.

I have the following problem :
Under an Access 2000 form I read and write simple hours
(no date, format 00:00:00) from a datetime field but when
I use the same form under Access XP (with the same
database/table), I read hours with a reference date
[30/12/1899] and if ever I try to write a simple hour, I
observe that the field is completed with 01/01/1900 date.
It's as if reference date had change between Access 2000
[30/12/1899] and Access XP [01/01/1900].

Does anybody confirm the problem?
Any solution to manage the same database with Access XP?

-
David

 

[Van T. Dinh]

AFAIK:

Access/JET/VD reference date is 30/Dec/1899.

MS SQL reference date is 01/Jan/1900.

It is not the problem of Access versions. It is because reference date is
different between JET/VB vs MS-SQL. Unfortunately, it means you cannot pass
date values directly between Access/JET/VB and MS-SQL. You need to convert
via String representation.