Tue, Oct 24 2006 18:00
Well...not quite LUA for Quickbooks
When I beta tested Quickbooks .... I did Vista on a standalone install...and then did a network install of Quickbooks 2007 on my SBS server to test out the new network install.. and then installed it on XP. It didn't dawn on me until today that I never did an XP in a standalone workstation setting (heck I even domain join a Media Center edition with a Banana hack) .... because if I had, I would have seen that the non admin mode that Quickbooks is touting is not quite universal..... LUA works in Vista.... but for the upcoming tax season... I can't run Vista.
Soooooo while us SBSers can look forward to the fact that we can do a network install and have the workstations run without admin rights, when it comes to our standalone brethren....they are outta luck.
(Update -- as long as you don't need to have online banking, online merchant services and what not ...it will "run" without admin rights... it's the online stuff that wants admin access... go figure....)
Not even the hacking registry info from the 2006 era works on the 2007 per this post --
"Here is what I found from Intuit Support. (I am still having a hard time believing what I heard even though I verified with a second level support person that what I am about to say is correct.)
Filed under: Security
QuickBooks 2007 only supports limited users in a multi-user environment. [IMHO, it still does not really support limited users .. keep reading.]
QuickBooks 2007 [still] requires that the user be a PowerUser (or Administrator) when used on a single PC running Windows XP (or Windows 2000). However [somehow] it will supposedly work on Windows Vista as a limited user. (There used to be work arounds so that limited users could run QuickBooks--granting rights to a limited set of files/folders and registry keys. The work arounds which worked with QuickBooks 2005 do not work with QuickBooks 2007. Intuit Support did not offer any similar work arounds for QuickBooks 2007.)
The Database Manager (which is used to share company files in a multi-user environment) is an application, not a service. That means that a user must log on to the server to cause the Database Manager to run. And that user must be an administrator! (Thus, IMHO, QuickBooks 2007 still does not completely support running as a limited user.) This means that I must log on to my server with an administrator account and leave it logged on all the time!!! (What are they thinking? Doesn't Intuit understand what a Windows service is? Don't they understand security risks at all? Or is it that they are almost a monoply and just don't care?)
You must have more than one PC to run in multi-user mode. (Note that I did not say that you can, but that you must. That is, Multi-User mode is required for more than one PC but is more than one PC really required for multi-user mode?) (I am still not believing this--see the comment below about running both server and client on the same PC.) I suspect that this really means that you must have more than one PC to run in multi-user mode as limited users.
It is possible for a PC to be both a server and a workstation, but a user on that PC must be an administrator (because that user needs to run the database manager application to share the company file and you must be an administrator to run the database manager).
I am having a hard time believing all this because it is so convoluted. If someone finds that I have misunderstood what Intuit Support told me (even though I have carefully reviewed my understanding with Intuit), please correct me.
I work for an IT Professional Services company and we provide IT management and consulting to many different companies. I have worked with many, many different Line Of Business applications that do accounting. They frequently have a shared file containing financial and other data and often a database engine. I have not seen ones that require someone to remain logged on to the server for the database to work. Most of them by now work fine with limited users. I find it hard to believe that Intuit still can't get this to work "right" (according to the specifications that came out with Windows 2000--over 6 years ago).
As I mentioned in my original post, I refused to pay money to Intuit until they fixed this limited user gaping security hole (requiring users to be administrators so that malware can easily install) in their software. IMHO, they still have not done so. Accordingly, Intuit offered to refund the money that I paid for QuickBooks 2007. Let's see, what other accounting software should I migrate to ... Microsoft Small Business Accounting? "