I am using an Access database behind some Intranet pages and I have an ASP script that updates one of the tables in the database.....straight forward enough !!

Unfortunately the update script works when run on 2 out of 3 Windows 2000 machines and fails with a datatype mismatch on the 3rd !! All machines are running the same code against identical copies of the database.

Any idea's anyone?

Can you post your code?

The code in question is:

"insert into user_time (initials, date_worked, time_from, time_to, num_hours) Values('" & request("u") & "','" & Request.Form("date") & "','" & Request.Form("time_from") & "','" & Request.Form("time_to") & "'," & Hours & ")"

It is probably a question of date-formats. Have you checked the locale settings?

I already have <%@Language=vbscript LCID=2057%> specified at the top of the script which has stopped previous date problems from occurring. Does this have an affect on the SQL dates?

Have you tried putting ## around Response.Form("date")?

Yes, I have tried the #'s. I have had problems with this machine before as it assumes American date format. Maybe this is causing the problem when writing to the DB.

What are the datatypes of the DBFields?

Try looking for differences between the three windows-installations - are they set to the same locale? Do they have the same level of patches? If you're using ODBC to connect to the DB check the ODBC-versions on the machines aso.