Is someone logging into and out of your server? You'll see this if your
locale is set differently for the different accounts. I've never
investigated the perfect/proper/whatever solution for this, but have fixed
it by logging into the server using the local admin account and changing the
default locale to, in your case, UK. See if that fixes it. Having said that,
if it doesn't (and I therefore fluked my fix), you should log in
interactively as the IUSR_ account your site is using and change the locale
for that account too. Log out each time to verify if the changes have taken.

Hope this does it.

Alan

"Paul Macdonald" <Paul@sanza.co.uk> wrote in message
news:014801c35f79$b0d44a10$a301280a@phx.gbl...
> Can anyone enlighten with any ideas as to why my
> recordsets would have suddenly changed from one day to the
> next from uk dd/mm/yyyy to an American mm/dd/yyyy, and how
> I can change it back ? Server regional settings are UK -
> dd/MM/yyyy.
>
> My code uses an ADO Connection using a DSN, with SQL
> Server 2000.80.194.00 driver.
>
> sample code goes
>
> set rcd=server.createObject("ADODB.Recordset")
> set rcd.activeConnection = c
> rcd.CursorType = 3'adOpenStatic
> rcd.LockType = 3'adLockOptimistic