vfp9 (see the subject) The file server and terminal servers are all Win2003. The workstations on the local network are Win2000 SP4 or WinXP SP2.
We have not been able to determine a single process when the error occurs. It seems to be random. It may not occur for a week or two so it is difficult to debug. I notice another email response from Mike Yearwood that (I believe) recommends having a separate dbc for the views for each user. We already do this for many views as it allows us to easily change a complex view in a prg. I think that the solution will be to have all view definitions in a prg - open a temp dbc for the user, then run the view definition in the prg as it is needed. That will be required one time. After that, the user specific temp dbc will have the view definition which we can use. We can delete the temp dbc with each update to ensure that the view definitions are always up to date. gendbc will automatically create the prg that is needed to create the view and it allows most of the views to be kept in the dbc with the tables. This is of value as we have 3 dbcs with hundreds of tables and at least 2 'standard' views for each table - one for a single record update and one for lookup purposes in grids. Hope that is clear. I appreciate any other suggestions. ----- Original Message ----- From: "Dave Crozier" <[EMAIL PROTECTED]> To: "'ProFox Email List'" <[email protected]> Sent: Tuesday, October 16, 2007 11:52 PM Subject: RE: VFP9 Error: database object is being used by someone else Kam, Need to know more info please. VFP Version? Under what circumstances are error messages generated - what is VFP doing? Server Configuration - 2K, 3k? Client configuration Win98, XP Vista ? Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kam Sent: 16 October 2007 23:00 To: ProFox Email List Subject: VFP9 Error: database object is being used by someone else This is multi-user software with thousands of installations. All seem to work fine with no problems related to having multiple simultaneous users except: We have one client that gets that error message often. They have about 40 users. The files are on a dedicated file server. Many users access through two dedicated terminal servers. About 6 users are connected locally on the network. When they get the error, there really are at least two users in the program so it seems like it is a valid message. Any of the users can get the message. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
