Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: surinder singh
  Where is surinder singh?
 mumbai
 India
 surinder singh
 To: jAy_Em Sancho
  Where is jAy_Em Sancho?
 quezon
 Philippines
 jAy_Em Sancho
 Tags
Subject: RE: Multi-User System
Thread ID: 188837 Message ID: 188846 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Tuesday, August 12, 2008 10:07:20 AM         
   


> Fellow Foxperts,
>
> Hello.. just wondering.. i want my system to be access by multi-users, and in my forms i declare a BEGIN TRANSACTION ... and END TRANSACTION and my object was linked to its corresponding field names, once i add a record to a certain master file and another user wants to view that master file the status bar says.. "Attempting to Lock..." i know the the reason why that's the error because of that BEGIN and END TRANSACTION command my question is.. aside from creating a dummy file for them to transfer all the entered data to the actual table, is there any other alternative to be access it in multi users? i didnt try yet the SQL insert into.., what if i used this should i encounter the same problem? is that necessary to declare BEGIN AND END transaction command? just hit me a tip for creating a system in multi users.. Thanks and More Power to us!!!

There are number of articles and samples regarding this on this site.

you may check
https://www.foxite.com/articles/read.aspx?id=75&document=moving-from-single-user-to-multiuser-in-vfp

or search for "single to multi user" here.

Hope you will find this link helpful!

-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
Check my blog for details: http://weblogs.foxite.com/sur200
----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.

ENTIRE THREAD

Multi-User System Posted by JAYEM SANCHO @ 8/12/2008 9:39:49 AM
RE: Multi-User System Posted by surinder singh @ 8/12/2008 10:07:20 AM
RE: Multi-User System Posted by Anders Altberg @ 8/12/2008 11:37:21 AM
RE: Multi-User System Posted by tushar @ 8/13/2008 5:13:11 AM