The tables have been formatted for Date/Time. However, some of the PC's read the date as 10/14/03 and others as 10/14/2003. This is causing errors with the queries and reports. The DB is located on a network drive so I do not see how some PC's are reading the date one way and some are reading it the other.
I have tried re-creating from a blank database the tables, however the same problem is occuring. Also looked through the tools/options but could not find any differences between the two PC's.
Does anyone have any ideas as to what is causing the date to be read differently? If nothing can be done, is there away to "force" the date to be one way or another (only thing is that the data for the date is imported in from a text file that is a system download which can not be changed)?
Thank you for any and all help,
PBrown
I have tried re-creating from a blank database the tables, however the same problem is occuring. Also looked through the tools/options but could not find any differences between the two PC's.
Does anyone have any ideas as to what is causing the date to be read differently? If nothing can be done, is there away to "force" the date to be one way or another (only thing is that the data for the date is imported in from a text file that is a system download which can not be changed)?
Thank you for any and all help,
PBrown