General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Frank.
>I have this problem that is driving me crazy. I have an app that dustrubuted at 8 different locations.(8 different servers). Both novell and NT. 1 nt server and 1 novell server keeps comming up with "database in use by another"
Does this happen when a form is being opened? Are you using views? If the answer to both of these is "yes" (as I suspect is the case), you're running into DBC contention. What's happening is that when the form opens the view, VFP temporarily locks the view's records in the DBC. If another user opens the form at exactly the same time, VFP can't lock the view's records because they're already locked, and gives this error.
There are several solutions to this, but the cleanest is to have a local rather than shared copy of the DBC. You move all your views to their own DBC, then at app startup, copy the views DBC, DCX, and DCT files to the local drive and open that copy. That way, there's no contention for DBC locking.
Doug
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only