Record Locking Problem

#1 (**permalink**) 10-Nov-2005, 21:09 PM

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):

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7089-record-locking-problem.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
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 (**permalink**) 11-Nov-2005, 20:08 PM

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" wrote in message
news:0B901E52-9960-4E29-A141-653E03935DD3@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
>

#3 (**permalink**) 11-Nov-2005, 20:09 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
>
> "KenDunne" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
> > 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 (**permalink**) 11-Nov-2005, 20:09 PM

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" 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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
but
> > > not let me make changes - but I can change the records!!!
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
> > >
> > > 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 (**permalink**) 12-Nov-2005, 22:39 PM

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" wrote in message
> news:45F0C984-CFE2-45CB-B1EB-EE0F13053646@microsoft.com...
> > I think something is really wrong!! My test database is a simple single
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
> really
> > > wrong.
> > >
> > >
> > > --
> > > Steve Clark, Access MVP
> > > http://www.fmsinc.com/consulting
> > > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
> > >
> > > "KenDunne" 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
> > > >
> > >
> > >
> > >
>
>
>