Pessimistic Record-locking

[Tarnish]

Hi all,

I have a database that I've split into front end and back end mdb files. I want to employ record level locking so that if one user is editing a record another user can't.

The original combined db was developed in 2000 format which didn't support record-level locking, but both parts have been converted to 2002-2003 format. The only other thing I can think of is that the record I'm trying to lock is based on a query and that, according to the Access Enterprise Developer's Handbook, data definition queries can't be locked for "edited record" which is basically the setting for record-level locking. I mention that just in the way of info because it might be the problem, but it might not be the problem (I don't know exactly what it would mean to lock the query versus locking a record).

Bottom line: the record level locking isn't working. I've set the backend to (open in shared mode) and (edited record locks), and I've set the front end to the same settings though I don't think that matters so much.

Anyone have any ideas?

Thanks, in advance.
T

 

[Tarnish]

I finally figured it out. That default setting in the tools>options only applies to datasheet views of tables/queries. For other objects, like forms, there is a property on the data tab for locking.

T