Locked records are not Locked

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Racer57 - 15 Jan 2004 14:55 GMT

Simple Access 2002 database with customers to call used by five users. I
have set Default record locking to "Edited Record" and check "open Databases
using record level locking".

I can still open two instances of the database and revise the same record
from both instances. How can I lock out a record that is being edited?

Signature

Paul Mazzola
General Manager-High Speed Data Services
Time Warner Cable
Eastern Carolina Division
Wilmington NC
Ph: 910-772-5793
Fax: 910-772-5796

Reply to this Message

"Petrucci2000" - 18 Jan 2004 21:00 GMT

Paul wrote:
--------------------

| From: "Racer57" <paulm@ec.rr.com>
| Subject: Locked records are not Locked
[quoted text clipped - 8 lines]
| NNTP-Posting-Host: 24.25.33.218
| Path:

cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGXS01.phx.gbl!TK2MSFTNGXA0
5.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl

| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.multiuser:36746
| X-Tomcat-NG: microsoft.public.access.multiuser
[quoted text clipped - 5 lines]
| I can still open two instances of the database and revise the same record
| from both instances. How can I lock out a record that is being edited?

With Default Record Locking set to "Edited Record" and "open Databases
using record level locking" the record should be locked when editing. Test
with another database file. If the problem persists you may need to have
the latest version of the JET Database Engine installed. See: How To:
Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

Reply to this Message