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

> 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
> http://forums.prospero.com/n/pfx/forum.aspx?webtag=ws-msdevapps&nav=messages
> Check the section named: "Access Code/Macros"
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
> Akron, OH, USA

Can you give me some alternative to solve my problem ?


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