Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Record Locking Problem

Discussion in 'Information Technology' started by KenDunne, Nov 10, 2005.

  1. KenDunne

    KenDunne
    Expand Collapse
    Guest

    I have been experiencing problems with record locking. Most people seem to
    struggle with unwanted locks but my problem is that I cannot seem to get
    record locking to work. I first spotted the problem on an application that
    was causing problems due to users changing the same records. Whatever I do I
    cannot get the records to lock and I am experiencing the same problem on a
    small test db designed to investigate the problem.

    I have set the database options as follows (which is my preferred option):

    Open Database use record-level locking - true
    Deafult open mode = shared
    Default Record Locking = edited

    I have also checked that the forms and queries have the record locking
    option set to "edited record"

    This SHOULD allow me to view the same record with two different forms but
    not let me make changes - but I can change the records!!!

    I have tried playing around with the options but all setups and tried it
    with a standalone and a split database but it still allows me to change
    records.

    I am using Access 2003.

    Am I missing an obvious trick?

    Regards

    Ken
     
  2. Loading...


  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    Open two instances of Access, and open the form in both.

    Edit record in F1. Now try to edit the record in F2?
    if Allowed in F2, then save F2. Now try to save F1. What happens?

    If some warning or alert hasn't triggered by now, then something is really
    wrong.


    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html

    "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    news:0B901E52-9960-4E29-A141-653E03935DD3@microsoft.com...
    >I have been experiencing problems with record locking. Most people seem to
    > struggle with unwanted locks but my problem is that I cannot seem to get
    > record locking to work. I first spotted the problem on an application that
    > was causing problems due to users changing the same records. Whatever I do
    > I
    > cannot get the records to lock and I am experiencing the same problem on a
    > small test db designed to investigate the problem.
    >
    > I have set the database options as follows (which is my preferred option):
    >
    > Open Database use record-level locking - true
    > Deafult open mode = shared
    > Default Record Locking = edited
    >
    > I have also checked that the forms and queries have the record locking
    > option set to "edited record"
    >
    > This SHOULD allow me to view the same record with two different forms but
    > not let me make changes - but I can change the records!!!
    >
    > I have tried playing around with the options but all setups and tried it
    > with a standalone and a split database but it still allows me to change
    > records.
    >
    > I am using Access 2003.
    >
    > Am I missing an obvious trick?
    >
    > Regards
    >
    > Ken
    >
     
  4. KenDunne

    KenDunne
    Expand Collapse
    Guest

    I think something is really wrong!! My test database is a simple single
    table, single form that I have split and loaded onto different machines. I
    can open the form on both machines and go to the same record. I can then edit
    and save the record in either form without any error messages.

    Any suggestions??

    "[MVP] S.Clark" wrote:

    > Open two instances of Access, and open the form in both.
    >
    > Edit record in F1. Now try to edit the record in F2?
    > if Allowed in F2, then save F2. Now try to save F1. What happens?
    >
    > If some warning or alert hasn't triggered by now, then something is really
    > wrong.
    >
    >
    > --
    > Steve Clark, Access MVP
    > http://www.fmsinc.com/consulting
    > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
    >
    > "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    > news:0B901E52-9960-4E29-A141-653E03935DD3@microsoft.com...
    > >I have been experiencing problems with record locking. Most people seem to
    > > struggle with unwanted locks but my problem is that I cannot seem to get
    > > record locking to work. I first spotted the problem on an application that
    > > was causing problems due to users changing the same records. Whatever I do
    > > I
    > > cannot get the records to lock and I am experiencing the same problem on a
    > > small test db designed to investigate the problem.
    > >
    > > I have set the database options as follows (which is my preferred option):
    > >
    > > Open Database use record-level locking - true
    > > Deafult open mode = shared
    > > Default Record Locking = edited
    > >
    > > I have also checked that the forms and queries have the record locking
    > > option set to "edited record"
    > >
    > > This SHOULD allow me to view the same record with two different forms but
    > > not let me make changes - but I can change the records!!!
    > >
    > > I have tried playing around with the options but all setups and tried it
    > > with a standalone and a split database but it still allows me to change
    > > records.
    > >
    > > I am using Access 2003.
    > >
    > > Am I missing an obvious trick?
    > >
    > > Regards
    > >
    > > Ken
    > >

    >
    >
    >
     
  5. German Saer

    German Saer
    Expand Collapse
    Guest

    You are not opening to different Dbs, are you?

    Make sure you open the same DB from both machines. That shouldn't happen at
    all.


    --
    ___________
    Thanks,

    German Saer
    Orlando, FL


    "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    news:45F0C984-CFE2-45CB-B1EB-EE0F13053646@microsoft.com...
    > I think something is really wrong!! My test database is a simple single
    > table, single form that I have split and loaded onto different machines. I
    > can open the form on both machines and go to the same record. I can then

    edit
    > and save the record in either form without any error messages.
    >
    > Any suggestions??
    >
    > "[MVP] S.Clark" wrote:
    >
    > > Open two instances of Access, and open the form in both.
    > >
    > > Edit record in F1. Now try to edit the record in F2?
    > > if Allowed in F2, then save F2. Now try to save F1. What happens?
    > >
    > > If some warning or alert hasn't triggered by now, then something is

    really
    > > wrong.
    > >
    > >
    > > --
    > > Steve Clark, Access MVP
    > > http://www.fmsinc.com/consulting
    > > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
    > >
    > > "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    > > news:0B901E52-9960-4E29-A141-653E03935DD3@microsoft.com...
    > > >I have been experiencing problems with record locking. Most people seem

    to
    > > > struggle with unwanted locks but my problem is that I cannot seem to

    get
    > > > record locking to work. I first spotted the problem on an application

    that
    > > > was causing problems due to users changing the same records. Whatever

    I do
    > > > I
    > > > cannot get the records to lock and I am experiencing the same problem

    on a
    > > > small test db designed to investigate the problem.
    > > >
    > > > I have set the database options as follows (which is my preferred

    option):
    > > >
    > > > Open Database use record-level locking - true
    > > > Deafult open mode = shared
    > > > Default Record Locking = edited
    > > >
    > > > I have also checked that the forms and queries have the record locking
    > > > option set to "edited record"
    > > >
    > > > This SHOULD allow me to view the same record with two different forms

    but
    > > > not let me make changes - but I can change the records!!!
    > > >
    > > > I have tried playing around with the options but all setups and tried

    it
    > > > with a standalone and a split database but it still allows me to

    change
    > > > records.
    > > >
    > > > I am using Access 2003.
    > > >
    > > > Am I missing an obvious trick?
    > > >
    > > > Regards
    > > >
    > > > Ken
    > > >

    > >
    > >
    > >
     
  6. KenDunne

    KenDunne
    Expand Collapse
    Guest

    No. I am opening the same backend database and can see the the changes that
    the different machines are making!!

    "German Saer" wrote:

    > You are not opening to different Dbs, are you?
    >
    > Make sure you open the same DB from both machines. That shouldn't happen at
    > all.
    >
    >
    > --
    > ___________
    > Thanks,
    >
    > German Saer
    > Orlando, FL
    >
    >
    > "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    > news:45F0C984-CFE2-45CB-B1EB-EE0F13053646@microsoft.com...
    > > I think something is really wrong!! My test database is a simple single
    > > table, single form that I have split and loaded onto different machines. I
    > > can open the form on both machines and go to the same record. I can then

    > edit
    > > and save the record in either form without any error messages.
    > >
    > > Any suggestions??
    > >
    > > "[MVP] S.Clark" wrote:
    > >
    > > > Open two instances of Access, and open the form in both.
    > > >
    > > > Edit record in F1. Now try to edit the record in F2?
    > > > if Allowed in F2, then save F2. Now try to save F1. What happens?
    > > >
    > > > If some warning or alert hasn't triggered by now, then something is

    > really
    > > > wrong.
    > > >
    > > >
    > > > --
    > > > Steve Clark, Access MVP
    > > > http://www.fmsinc.com/consulting
    > > > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
    > > >
    > > > "KenDunne" <KenDunne@discussions.microsoft.com> wrote in message
    > > > news:0B901E52-9960-4E29-A141-653E03935DD3@microsoft.com...
    > > > >I have been experiencing problems with record locking. Most people seem

    > to
    > > > > struggle with unwanted locks but my problem is that I cannot seem to

    > get
    > > > > record locking to work. I first spotted the problem on an application

    > that
    > > > > was causing problems due to users changing the same records. Whatever

    > I do
    > > > > I
    > > > > cannot get the records to lock and I am experiencing the same problem

    > on a
    > > > > small test db designed to investigate the problem.
    > > > >
    > > > > I have set the database options as follows (which is my preferred

    > option):
    > > > >
    > > > > Open Database use record-level locking - true
    > > > > Deafult open mode = shared
    > > > > Default Record Locking = edited
    > > > >
    > > > > I have also checked that the forms and queries have the record locking
    > > > > option set to "edited record"
    > > > >
    > > > > This SHOULD allow me to view the same record with two different forms

    > but
    > > > > not let me make changes - but I can change the records!!!
    > > > >
    > > > > I have tried playing around with the options but all setups and tried

    > it
    > > > > with a standalone and a split database but it still allows me to

    > change
    > > > > records.
    > > > >
    > > > > I am using Access 2003.
    > > > >
    > > > > Am I missing an obvious trick?
    > > > >
    > > > > Regards
    > > > >
    > > > > Ken
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >
     

Share This Page