Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
  Where is RONALD STARK?
Subject: RE: record lock
Thread ID: 50997 Message ID: 50999 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Tuesday, September 07, 2004 8:25:45 PM         

Hi Ronald

> I'm working with foxpro and an access database (through odbc) and I want to know how to lock the record that I'm reading to update after the changes that the user will make.
> The situation is as follows: I have a form where I show the information of some record to be modified in that form and I don't want to anybody can read that record until the update was performed.
> Thanks in davance and regards

I don't think you can lock the record in Access using ODBC - it only supports page locking anyway.

If no-one else can help you, maybe you should try asking on the MSDevApps forum - they have a section dedicated to Access and one of the Access MVPs may know how you can do this. The URL is


Check the section named: "Access Code/Macros"

Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA


record lock Posted by RONALD STARK @ 9/7/2004 8:12:50 PM
RE: record lock Posted by Andy Kramek @ 9/7/2004 8:25:45 PM
RE: record lock Posted by RONALD STARK @ 9/8/2004 12:34:10 AM
RE: record lock Posted by Andy Kramek @ 9/8/2004 2:27:38 PM