Locking records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a simple question (I hope). In the VB I need test the state of
each record - when I move throw the records and the actual record edit
someone else, I need run some routine. I know, that the state of current
recors is shown on the record selector, but it is useless for my. Is there
any other way, how I can test the state of the record? Properties or methods?
Thank.
 
OK, I will try next offer. I have an open forms with some records in it. It
makes no odds how many. The same forms can open more then one users in the
same time (multiuser database). When one user change the data in a record,
this record will be locked, no-one other user can edit or delete this record.
In the form is record selector - in the left of window with the form and on
the top of this selector are graphical symbols for viewing state of the
record (locked, edited atc). I'am looking for: When I will move to the next
or previous record in the form, I need test the state of record, which will
be active and get focus. I have some function in visual basic, which insert
some informations to the form (photos atc) for corresponding record and i
need test in the VB, if the record is locked or not. My question is - is in
the VB some properties or function or method, which tell me, whether current
record in the form is locked? Sorry for my english.

Rick B píše:
 
OK, I will try next offer. I have an open forms with some records in it. It
makes no odds how many. The same forms can open more then one users in the
same time (multiuser database). When one user change the data in a record,
this record will be locked, no-one other user can edit or delete this record.
In the form is record selector - in the left of window with the form and on
the top of this selector are graphical symbols for viewing state of the
record (locked, edited atc). I'am looking for: When I will move to the next
or previous record in the form, I need test the state of record, which will
be active and get focus. I have some function in visual basic, which insert
some informations to the form (photos atc) for corresponding record and i
need test in the VB, if the record is locked or not. My question is - is in
the VB some properties or function or method, which tell me, whether current
record in the form is locked? Sorry for my english.

Rick B píše:
 
You can try to lock certain record and check for error - once error occurs -
then records is locked
 
There are lock options in the Tools/Options for the database. This is all
built-in to Access. Personally, I have never experienced a record locking
propblem with my 25 user database.

Access seems to handle this pretty well with just the default locking
settings.


Rick B
 
I know about lock option in the Tools, and i know, how to lock one record or
all records, I know pesimistic and optimistic locking, but I don't know, how
i can test the open record in the form from visual basic.... For me is
important know, if the record is locked or not. I don't have problem with
built-in locking, only don't know, how test state of the record (in the
form), which is locked.

Å mejki
Rick B píše:
 
Back
Top