< With each user getting a copy of their own DBC for the remote views,
the
locking issues are substantially eliminated...>
With the number of users that are using this system, let alone users
coming and going, it would be a maintenance nightmare for the IT
department and for us to separate the databases by user. We've talked
about it and decided it's simply not an option...
Thnx for the reply though!!!
Barry Childs
Software Developer
Peak Software Systems, Inc.
Phone: (801) 572-3570 ext. 319
eMail: bchilds .AT. peakinfo DOT com
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces .AT. leafe DOT com] On
Behalf Of jgunva - John C. Gunvaldson
Sent: Thursday, July 31, 2003 2:23 PM
To: ProFox Email List
Subject: RE: Database Locking On Citrix
Hi Barry,
The issue with .DBC being briefly locked when Local or Remote views are
included in the DBC is a pretty well know issue with VFP. Some of the
tricks
I use...
1. Separate DBC for Views
2. Ensure all of the remote views are stable, and read only in the .DBC
3. Compile the DBC into the clients EXE /or/ provide a copy of the DBC
in
the users private Citrix path - but not shared on the central data
directory...
With each user getting a copy of their own DBC for the remote views, the
locking issues are substantially eliminated...
hth
John C. Gunvaldson, CNE, MCP
Database Developer
San Diego, CA
[excessive quoting removed by server]
©2003 Barry Childs |
