Recent content by spierian

And I'm glad you did! I found that not all Windows Updates had been properly installed, so fixed that (your earlier suggestion). Still no joy. Then tried the aquare brackets on the Action field and hey presto - it worked. Many, many thanks for persevering. It still doesn't explain why...

Catch 22 - I am unable to check the home PC - motherboard gone which is why I am now using the laptop. When the PC is back working, I won't care about the laptop! Sound like a likely solution - but tried and it made no difference. Just to be sure, it should look like this? UPDATE SS1066 SET...

On the home PC and laptop Access was loaded from the same CD - Office 2000. To be exact, Access 2000 (9.0.2720).

Home PC (no problems) and laptop (problems!) are both XP Pro and SP3. Shared web server is a commercial service with (I think Win 2003). In any case, it works just fine.

Yes, good point. I've tried the SQL in various forms, removing fields one at a time - still the same. The point is there IS no syntax error. I did copy the Access db across to the laptop. Could you explain what you mean by references? Anything spring to mind that might cause these...

Thanks for replying. I checked country settings - all as should be including decimal. I did not give details because the point is identical code is behaving without errors on 2 machines and giving errors on a third (identical on the face of it). The problem is not the code, it's the setup...

I have a website which uses a series oif ASP/VBscript scripts to access and update an Access database. It has run for years on a shared commercial service. I also have a replica of the wesbite on my home pc for development and testing running under XP Pro and IIS. All works fine. Recently...