|It is the same with SQL Server and has always been an irritant. With SQL Server you have sql profiler and you can trap the actual statement passed to the database including data. You can then manually execute the command in management studio. This gives you a more detailed error response and you can use the mark I eyeball to inspect the data.
I know you can execute sql strings in Access but I do not know where to trap the command passed to the database from the client.
I would strongly suggest moving the database from Access to SQL server if possible.
Never underestimate the power of human stupidity