Access 2000 problem

[Gregg]

We have a database created with Access 97. It has a query
that looks at the current information on an opened form
and from there generates a report of that form. The query
works just fine in Access 97, 2002 & 2003. In Access 2000
it gets all the information on the form except a date
field, which it leaves blank. Any ideas on why this only
happens in Access 2000, and is there some fix or
something that I can apply to the 2000 versions?

Thank you

 

[Micheal]

I'm having the exact same problem! I've done all the
service pack updates etc. for Office 2000 and still the
problem exists in Access 2K. Is there anybody that can
help on this problem?
Thank you for your help,
Micheal

 

[Susanne]

Dido on all

-----Original Message-----
I'm having the exact same problem! I've done all the
service pack updates etc. for Office 2000 and still the
problem exists in Access 2K. Is there anybody that can
help on this problem?
Thank you for your help,
Micheal
.

 

[Joe]

I believe Microsoft changed the (default) format for dates in Windows 2000. Check whether your table definitions and queries are specifying date formats. This may also be affected by the configuration defaults selected by the Windows user. Check that these configurations are all the same

----- Susanne wrote: ----

Dido on al