Lock field as opposed to whole record?

[macroapa]

Hi,

I have a FE/BE database with each user having their own copy of the
FE.

In the FE I have a form bound to a linked table to the BE.

The form is in the tabular view.

Now I have the record lock of the from set to 'Edited Record' so that
if one user is already editing a record, another user cannot edit it.
However, what i would prefer to do is just lock the fields that are
being edited of the record as opposed to the whole record.

Is this possible or do I need to restructure my table?

The table is a simple 'booking system' with each record being for a
user for each day and the fields being the username, date, and then 48
fields for each 30min timeslot in the day. IE:

Name Date 8am 8:30am 9am 9:30am
Steve 01/01/2000 avail busy meetng avail
Fred 01/01/2000 busy avail avail avail

Thanks for any pointers.

 

[Peter Hibbs]

Macroapa,

No, I don't believe it is possible, Access can only lock a whole
record and not individual fields on a record. In any case, your table
design is not correct, it needs to be properly normalised, that is you
need a separate record for each booking time. Then you will be able to
do what you ask.

Have a look at :-
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180
which shows an appointment system very similar to what you are trying
to do. It actually uses a flex grid control to display the
appointments (which you may or may not want to use) but the table
scheme is very similar to what you need to do.

HTH

Peter Hibbs.