Database sharing/locking

[bigfella]

I am developing an Intranet using coldfusion with MS Access for the database.

How do i detect if a record is currently being edited, thus denying a second user from editing it.

I have turned on default locking in the database hoping it would return an error that i could cfcatch, but it doesn't work.

Can anyone help???? [sig][/sig]

 

[Guest_imported]

What kind of errors are you getting in your database?

You can try setting "Single Threaded Sessions" on in the Cold Fusion Administrator.

 

[bigfella]

There's no error.

If someone is modifying a record, i want to deny someone else from modifying the same record simultaneously. I thought setting the default record lock to 'edited record' in Access would do this for me, but it doesn't?? [sig][/sig]