Re: Re: Database locked

Troopmaster recommended that we first try checking and or unchecking the passive mode found under troopmaster.net.  This did not work for us.
 
We had the same problem with the locked data base for a particular user. Keep this in mind if you unlock the data base the information that was put in when the database was locked will be lost. We were able to correct the problem with the use of the "unlock Database" found under in the troopmaster dotnet.
  ----- Original Message -----
  From: kthoman2005
  To: TMTUG@...
  Sent: Monday, June 01, 2009 10:22 PM
  Subject: [TMTUG] Re: Database locked






  --- In TMTUG@..., "W. B. Stringfield" <wbstringfield@...> wrote:
  >
  > I assume by locked you mean that when you try to download from DotNet the
  > database can not be downloaded and acts as if someone with write capability
  > were logged in..
  >
  Yes that is what happens.  The database can not be downloaded.

  > Is that true for the person who had the problem with slow response that
  > seems to have caused the problem? Have they tried to log in and download?
  >
  The person that had the problem can not download the data either.

  > Has the database administrator tried the "Unlock Database" button on the
  > "TroopMaster DotNet" page under the "File" menu?
  >
  I am the Administrator, and I get the "The database is locked by Mark."  "Would you like to open the database in Read Only Mode?"
  I say yes and it looks like it downloads a copy of the database.

  Is it possible that the database I just accessed corrupt?
  Should I trust it?

  > I am curious about what happened and how to correct the problem.
  >
  > Butler
  >
  >
  > _____
  >
  > From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
  > kthoman2005
  > Sent: Monday, June 01, 2009 8:28 PM
  > To: TMTUG@...
  > Subject: [TMTUG] Database locked
  >
  >
  >
  >
  >
  > Before I start my question, please understand that I have been using
  > Troopmaster/Packmaster since 1994, DotNet since maybe 2004. I printed out
  > the User Guide the day I started using Troopmaster ME.
  >
  > I also try and search the Yahoo group postings before posting a question.
  > Right now that function is not working for the group as Yahoo is migrating
  > to a new method for searching posts.
  >
  > Now for my question -
  > For the first time since using Troopmaster, we now have a locked database.
  > Seems that someone was running a report and their computer hung. After
  > waiting a looong time for the report to finish, the user forced Troopmaster
  > to quit and now the database is locked.
  >
  > We just updated to the latest version 4.01d about 2 weeks ago.
  >
  > Any advise on unlocking the database would be very appreciated.
  >
  > Thanks,
  > Karen
  >