[AccessD] Date standardization

Hi Jim,

Yes, it's confusing all right. :-)

Is this inability to access the backend database a permanent affliction?

What sort of "issues" are you experiencing?  Can you give any examples?

On the basis of what you have told us so far, it almost seems like the data 
in the backend may be in a Text field, not a Date/Time field.  Possible?

Otherwise, I can't think of any way any format applied to the design of the 
table, or the format of any data controls on your forms, or whatever, could 
make any impact.

I suppose another thing to consider might be the regional settings of the 
machine where the backend is located?  But I suppose you can't access that 
either.

Regards
Steve


--------------------------------------------------
From: "Jim Lawrence" <accessd at shaw.ca>
Sent: Wednesday, June 16, 2010 5:24 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Date standardization

> Hi Steve:
>
> Thanks for that but my dates problems appear to be related to various date
> formats that a number of the data tables have in them. I only have access 
> to
> the FE and my test BE but the real BE is where the problem is. For some
> reason there are date issues related to the data in the 'other' BE. If I
> could get to the problem data it could be solved in minutes but currently, 
> I
> just do not know why there is a date problem and no amount of coding seems
> to be able to resolve it.
>
> Confused? So am I.
>
> Jim