multi-user conflict due to ODBC settings?

[Donna]

I have an Access 2000 database on an NT server running
iPlanet Server and using JSP. My web app (designed in
Dreamweaver) lets users add a conference room reservation,
delete, and view existing reservations.

When 2 users attempt to click Submit at the same time (to
add a room reservation), the database dies.

I have record-locking in Access checked and also Default
Record Locking set to: Edit Records.

Is there something in the ODBC driver settings that I need
to do to have the database process multiple requests
without crashing?

thanks for any help.

 

[david epsom dot com dot au]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0]
"Threads"=dword:00000003

Try changing this registry value to 1

You probably have to restart the iPlanet Server to get Jet to restart.

I would be grateful if you could report if this fixed the problem.

(david)