D
David UTEAU
Hello
I had an ADP project developed 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
(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
I had an ADP project developed 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
(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