Home Page link  

Quicken file on network

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Quicken file on network Andy 04-05-2008
Posted by Han on April 6, 2008, 5:00 pm
Please log in for more thread options

> Newsgroups: alt.comp.software.financial.quicken
> Subject: Re: Quicken file on network
>
> Han wrote:
>> <script etc snipped>
>>
>> Thanks Andrew, I get it. My Reference Manager database system
>> probably does something like that, because if I have a DB open, I
>> can't even copy its files to another drive. The program also writes a
>> *.loc file to disk, and deletes it when the program or DB is closed.
>> Or is "locking" a file something different?
> The "inuse" file I used is what I called it - a sentenal (misspelled!
> Should have been sentinel - my bad). It stands guard.
>
> It depends. Locking a file is somewhat different IFF your OS supports
> file locks. Indeed, anything that prevents access can be thought of as
> a lock. A script such as the one I posted "locks" your Quicken
> database. About the only thing different is that this "lock" is
> applied by a user and has the semantic of meaning "Hey I'm working on
> this". Effectively it's saying "I want exclusive access to <resource>"
> where <resource> in this case is a Quicken database. So it's like a
> reservation or like checking a book out of a library.
>
> This is also what's called a cooperative lock in that all people
> passing through this script will be prevented from using <resource> if
> somebody else is using it. Anybody ignoring this script and simply
> opening the Quicken database obviously will not be impeded.
>
> If your OS supports locks - or more specifically if the file system
> supports locking - then the locking is enforced by the file system
> itself when you attempt to fopen or fwrite the file. Effectively this
> non-cooperative file locking is really no different except to say that
> there is really no other way to write the file thus your "cooperation"
> is not required! ;-)
>
> IOW You ain't getting to write this file bud because the file system
> is not gonna let you.
>
> Quicken doesn't have non-cooperative locking - this script is a hack
> to provide it via cooperative locking.

OK. Apparently, Reference Manager uses more sophisticated database
protection. It has some way to enforce 1 of 3 different sets of "access
rights": Read-Only Share, Read-Write Share, and Read-Write Exclusive.
Mine is a stand-alone version of software to manage a "library" of
scientific research articles, and ways to automatically output
bibliographies of quoted articles in a wordprocessor.

Everyone has for years been complaining that this version opens files by
default in Read-Write Share mode, which prevents you from editing some
useful stuff, such as journal titles (JBC is the same as J. Biol. Chem.
is the same as Journal of Biological Chemistry, and depending on
circumstances you might one or the other). At present you have to
expressly open the database in Read-Write Exclusive mode to do those
things. This is a pain in the 4$$. There is also a more expensive
network version, which would support simultaneous use of a database from
different computers. Made by Thomson ResearchSoft.

--
Best regards
Han
email address is invalid

Posted by Eric on April 6, 2008, 6:25 pm
Please log in for more thread options
How about running Q using a Batch on any PC and if your "real" Qdata file
set was called RealData and the Batch sequence on all PCs was:

1. CD to the directory holding RealData.* which may be on any drive
2. If not exist RealData.IDX goto Notify
2. rename RealData.* to RunData.*
3. Start "" /WAIT "C:Program FilesQUICKENWqw.exe" RunData
Note that you can have Q back up data to another drive or directory
4. Rename RunData.* RealData.*

:Notify
Echo Quicken is in use on another PC
pause

Then if someone on another PC ran the same batch a warning is issued about
another PC using Q.

Eric


> Andy,
>
> I have long wanted to do something like this but Quicken seems to be
> implemented assuming a single client connection to the database. To
> overcome this I have considered using a script to launch Quicken that will
> first "check out" the files to the local computer before editing. Then
> have the script do a "check in" when it's done. I'm using quotes around
> check out/in because it isn't real CM. My thinking is that real problems
> could happen if two Quicken clients were reading/writing to the same file
> set at a given time.
>
> I think your terminal server idea is the safest approach.
>
> Scott
>



Posted by Pete on April 5, 2008, 9:23 pm
Please log in for more thread options
Andy wrote:
> I know that installing Quicken on multiple computers is allowed by the
> license. I also know that some people use Quicken with their file
> stored on their local network. I realize that Quicken doesn't
> officially support this. I'd really like to do this, assuming its
> relatively safe. I'd like to hear people experiences doing this and
> how well it works for them, and any issues they may have run into.
> Thanks

Andy - I have been doing this successfully for at least 3-4 years. I
have a file server (ie. underpowered PC) in my basement which remains
powered up continuously. I have two other networked desktop PCs from
which I access the server data file. I have never had any file
corruption issues. If I mistakenly leave quicken running on one PC, and
try to access from the other, I just get some message that the file is
unavailable.

By the way, I always do my backups to the local PC I'm using. This way
my primary data file is on the server and my backups are on the two
other machines. To do the backups more easily, you can create an
identically named back-up folder on the two remote PCs - I use
c:quicken backups. This way when you go to back up to this folder
once, it will default to that folder on the current PC, no matter which
PC you're using.

I've been very happy with this set-up.

Pete

Posted by bjn on April 6, 2008, 8:33 am
Please log in for more thread options
wrote:

>I know that installing Quicken on multiple computers is allowed by the
>license. I also know that some people use Quicken with their file
>stored on their local network. I realize that Quicken doesn't
>officially support this. I'd really like to do this, assuming its
>relatively safe. I'd like to hear people experiences doing this and
>how well it works for them, and any issues they may have run into.
>Thanks


Do not, repeat DO NOT, try this with the abomniation known as Microsoft
Windows Home Server. Your data WILL be corrupted.


Posted by Eric on April 6, 2008, 6:28 pm
Please log in for more thread options
How about running Q using a Batch on any PC and if your "real" Qdata file
set was called RealData and the Batch sequence on all PCs was:

1. CD to the directory holding RealData.* which may be on any drive
2. If not exist RealData.IDX goto Notify
2. rename RealData.* to RunData.*
3. Start "" /WAIT "C:Program FilesQUICKENWqw.exe" RunData
Note that you can have Q back up data to another drive or directory
4. Rename RunData.* RealData.*

:Notify
Echo Quicken is in use on another PC
pause

Then if someone on another PC ran the same batch a warning is issued about
another PC using Q.

Eric

>I know that installing Quicken on multiple computers is allowed by the
> license. I also know that some people use Quicken with their file
> stored on their local network. I realize that Quicken doesn't
> officially support this. I'd really like to do this, assuming its
> relatively safe. I'd like to hear people experiences doing this and
> how well it works for them, and any issues they may have run into.
> Thanks



Similar ThreadsPosted
Accessing .QDF File Over Network November 21, 2006, 6:05 pm
Quicken on a home network. December 10, 2006, 7:04 pm
Shared (Network) Quicken 2007 August 22, 2007, 12:54 am
How to shrink your .QPH file (quotes file) October 14, 2006, 11:55 pm
Quicken file backup October 14, 2006, 7:39 pm
Quicken QFX file format April 4, 2007, 10:59 am
Current Quicken File June 2, 2007, 5:17 am
Quicken File Sharing? August 22, 2007, 9:15 am
Quicken file security November 30, 2007, 4:33 am
How do I export a single brokerage account from Quicken to a new Quicken File? November 14, 2006, 12:18 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap