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?
 surinder singh
 To: jAy_Em Sancho
  Where is jAy_Em Sancho?
 jAy_Em Sancho
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

or search for "single to multi user" here.

Hope you will find this link helpful!

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.


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