Help with Stopping Multi Usee Access and Chat

Hello,

Here's my question. One of my clients is running QB pro enterprise

9.0. End users can arbitrarily turn multi-user hosting on or off. They don't even have to be logged on to a company file or even have a user name and password. Thy simply file/utilities/enable multi user hosting and whamoo, crashola!

After they cause these access problems, they claim they never touched anything *ughh*. I can't really blame them, software needs to be bulletproof and take into account end user errors. I'm shocked that QB let's you toggle multi user access on or off without admin privileges or any privileges for that matter.

I have tried stopping the service QBDB19, changing the password to an incorrect password, everything. Yet when you turn on multi user access, quickbooks 'repairs' the problem by re-establishing the service credentials and turning the service on.

Is there any way to stop this madness?

Also, there are 9 people in the acct department that use the 'chat' feature to socialize during working hours. The acct manager wants that turned off. Any way I can turn it off permanently? When I disable it through QB, they simply enable it again.

Reply to
miguel
Loading thread data ...

Does that fact that any user that can run QB can also delete the data file trouble you?

Reply to
Haskel LaPort

Shouldn't cause a crash, unless of course you don't have a file server for the data file and the first person in is the machine that hosts and everyone else tries to host it (same file) as soon as they get in.

FYI no file open they are ADMIN by default. (At this point they can create a new file.)

Doing just exactly what it is supposed to do and what you want and expect it to do.

Buy a file server that is never turned off and host the file there. Then there is never a reason for a user to turn on multi-user hosting.

As to this, send out a memo anyone using chat gets fired.

You seem to have a people problem in the office not a technology problem. Everyone in a room for 15 minutes and explain the problem and the fix and remind them of the employee manual on chat.

Reply to
Golden California Girls

How the heck can a user get the exclusive access to the file needed to serve it while another instance of the server is running? Did you f'up the file and user permissions trying to over secure it? My guess is the repair you need is to uninstall QB from the server and re-install so that all the correct permissions get re-set and then leave it alone. Depending on what you did you may need to do this on the client machines as well. When QB is set up as QB expects (demands) it knows which files are already open and won't crash. Maybe you better go and read the multi-user installation section for the first time.

And, yes QB is a gaping security hole, welcome to the wonderful world of Intuit.

Finally as you have Enterprise, call the 800 number to the Philippines as you have a customer support contract.

It is the only true solution. Tell them it is logged and the boss is reading the logs. To be frank do you want employees who are willing to steal time (money) from the company doing the books? And if it is slow enough they have time to chat excessively you likely can fire at least one of them and save the company some money.

P.S. you sound like you are in IT. Any company big enough to have real IT is too big for QB. Move up the food chain. You will be happier.

Reply to
Golden California Girls

I did not know that they can do that. They have r/w privs on the data file in order for QB to work properly since its locked by the SQL they should not be able to go into the folder and delete the QB file. But if there is another way do delete it then yes, that's disturbing.

Me thinks you are confusing the QB database engine with Microsoft SQL.

Reply to
Haskel LaPort

I fully agree, he hasn't a clue about QB. Heck, he may not even have the QB SQL service, a totally different beast from MS SQL running on the server. That would explain all his symptoms. Of course if he would fully describe his setup and what he fiddled with or changed that would be useful data points.

Reply to
Golden California Girls

I have both. You have broken the installation or never set it up correctly in the first place. Setting a client machine to serve files does not cause the symptoms you are describing. Seven years of experience says so. If the software tries to serve a remote file it will get an error message.

Reply to
Golden California Girls

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.