Re: Record Locking for Editing.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Well, I don't have access to a DB2 database so you cannot make any test or
tell you anything more on this; I'm just telling you that you cannot expect
the same capabilities about record locking when you don't use JET as the
backend database.

If you want plan to use DB2, you should make sure that you won't have two
users trying to edit the same record at the same time; either by changing
the design of the database - for example by splitting a table into two or
more tables - or by implementing your own locking mecanism.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"New" <New@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B6601CB-6FDD-4811-9B1D-013634EF0B0A@xxxxxxxxxxxxxxxx
Hi Sylvain.

Thanks For the Reply.

After reading your post i tried to Implement Optimistic Record Locking.
I Have changed my Form data Property -> "Record Locks" to "Edited Record"

Now the second user is gettiing error message as "No Current Record"
(Error
Number is 3021) when he tries to save the record .

1) Please let me know whether i am going in right direction.
2) How do i need to refresh the Current record for the second user after
seeing the error message.

Thanks In advanse.

"Sylvain Lafontaine" wrote:

For what I know, Access don't support Pessimistic Record Locking for
Editing
when the backend database is not the JET database engine (ie., when it's
not
an MDB or ACCDB database file); so you cannot have or use this feature
when
working against DB2, SQL-Server or Oracle.

What Access is supporting in these cases is Optimistic Record Locking:
the
second user will see an error message but only when he tries to save the
record (and not be blocked directly at the beginning if he tries to edit
a
record already opened for edition as it is the case with Pessimistic
Record
Locking.).

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam
please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"New" <New@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F3A169CC-3AE1-4B28-BA56-FD16520772AA@xxxxxxxxxxxxxxxx
Hi ,

I am new to Access. I am working on access forms as front end and my
Backend is Db2.

Right now two or more users can update the same record at same time
.If
one
user is updating a record and if second user tries to update same
record i
want to show error message.

Please help in Record Locking for Editing.

Thanks in Advanse.






.

Relevant Pages

  • Re: MS Access - Only one person can open database at a time
    ... one person can get into the database at a time. ... Is the second user getting an error message? ... Is the scenario UserA can get into mdb and UserB can't? ...
    (comp.databases.ms-access)
  • Re: MS Access - Only one person can open database at a time
    ... Do you have /excl in the command line to open the database. ... Is the second user getting an error message? ...
    (comp.databases.ms-access)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Cannot open my own Databases
    ... Windows Administrator and loads each of these service packs. ... If I have guessed correctly about the error message you see, ... See http://www.QBuilt.com for all your database needs. ... it's possible that the correct workgroup information file ...
    (microsoft.public.access.security)