Solved

Problem with NT and Visual Fox

Posted on 2001-07-16
3
139 Views
Last Modified: 2012-06-27
We have a process in Visual Fox which uses a database file in share mode for a certain number of users. Every day we need to update this database file in exclusive mode but any user remains using the file (because didn't logged off) then we cannot update the file, so in order to make our update we need to kill the sessions which are holding the file. This we have to do it manually right now, but since this is a process that runs at night we are looking for a way to kill this sessions automatically.
Somebody help us????
0
Comment
Question by:polloferoz
  • 2
3 Comments
 
LVL 23

Accepted Solution

by:
slink9 earned 135 total points
ID: 6286914
Before killing the process you need to consider the possible data loss from dropping an open connection within VFP.  You could end up with data corruption or loss if a record is open for editing when you kill off the connection.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 6713230
Hello all,
I am Computer101, a moderator from Experts-Exchange and also an expert within this topic area. This question has been open a long time.  What I am going to do is allow feedback from the questioner and experts.  If it is not resolved, I will delete or accept an answer based on the info I have been given, Experts, feel free to offer input.  I will monitor these questions for a period of 3-5 days and come back and evaluate.  I will have another moderator (who is also an expert in this topic area) look at the question also to ensure we do the right thing for this question.

Thank you
Computer101
Community Support Moderator
0
 
LVL 1

Expert Comment

by:Computer101
ID: 6742354
Comment from slink9 accepted as answer.

Thank you
Computer101
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Often we come across situations wherein our batch files would be needing to reboot Windows for a variety of reasons. A few of them would be like: (1) Setup files have been updated whose changes can take effect only after a reboot …
In a recent article here at Experts Exchange (http://www.experts-exchange.com/articles/18880/PaperPort-14-in-Windows-10-A-First-Look.html), I discussed my nine-month sandbox testing of the Windows 10 Technical Preview, specifically with respect to r…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now