Peter J. Boettcher — Fri, 18 Jan 2002 14:06:37 +0000

By error trapping I meant, you might be using "On Error REsume Next" in your asp code then all errors would be ignored (or handled by the code in your page). When I'm having a problem the first thing I do is comment out that line so I can see the real error.

The fact that you're using names instead of numbers shouldn't be a problem as long as your relationships are setup correctly.

akohl — Fri, 18 Jan 2002 06:48:21 +0000

I'm using locktype number 3.
ms access 2000 database.

I didn't quite understand what you meant by trapping an error. Would you please elaborate on that point.

The field has a look up combo box to display, in access, the names of the categories and books rather than the numbers, even though the fields contain only numbers.

Could this be an issue here?

Peter J. Boettcher — Thu, 17 Jan 2002 14:41:34 +0000

This script looks ok. Are you using adLockOptimistic locktype? Do you have On Error Resume Next, maybe it's trapping an error and you're not seeing it?

Are you using Access or SQL Server? If you're using SQL Server then you should start using Stored Procedures/Views they are so much faster than using the RecordSet object, and are easier to manage.