PDA

Click to See Complete Forum and Search --> : Simply Accounting Multi User access problem


TimeTraveller
03-22-2006, 02:37 PM
Environment. XPPro SP2 Simply 2005 Pro, MSWorks 8.0, Avast Antivirus, Aluria Spyware Eliminator, MSOffice Basic 2003. 2 PC's, Peer2Peer

Simply worked perfectly in my office. 2 PCs in P2P. Lan..worked beautifully in multi-user mode.

Installed computers, was just about to step out of clients office when...aargh. Disaster.

User1 on PC1 opened up Simply in MultiUser. User2 opened up Simply in Multiuser on PC2. Got the following error

message (may not be exact but...)


"Other users are currently working with this company. You may open the company in multi-user mode or wait for other users to stop using th company and try again"

Both users are in multi-user mode! This worked perfectly in my office!


After a couple of tries, it gives a message that the 2nd users password and/or user name are invalid. However,

the 2nd user can log in fine if she is the only user.

Password and user names are valid, as all users can connect to the database and open or use it when only one person has it open.


After checking everything I could think of, I pulled the computers out of the office, and reinstalled everything, and bingo...worked beautifully again in my office. Took them back to the clients office and as soon as they started to try and use Simply in multi-user mode, got the same error.

We did a fair amount of configuration on those computers after we put them back in the clients office, (printer drivers, other accounting SW, files and settings transfer etc ) so it would be pretty difficult to undo everything step by step without being very disruptive to the office, so I'm hoping to figure out what the problem might be and fix it directly rather than by process of elimination.

The X-Perts as Simply are stumped. We have created new companies, tried other databases, reset users and passwords, and the issue remains. It can hardly be a corrupt database. Maybe, but I don't think so. What else
could it be?

MSWorks 8.0 is installed on this computer, along with MSOutlook. Could either of these applications be causing some kind of interference since I gather they use Jet 40 as well?


Len Ralph

TimeTraveller
03-23-2006, 12:59 PM
No replies ! However perhaps my sad journey may be of use to someone else if they hit this snag.

Found out that if I move Simply DB to another computer on the network, it opens and works perfectly in multiuser mode with both users over the network. If I move it back to it's original location the problem reappears, so it appears to be an environment/permissions issue.


TimeTraveller
info@e-pni.com
www.e-pni.com

tech@cstt.com
04-03-2006, 04:02 PM
I have the same problem as you. However, my set up may be different. My boss wants me to put the Simply Accounting 2004 databasename.SDB file on our Linux file server. It works fine in single usermode but when I try to access it in multiuser mode I get the familiar message "Other users are currently working with this company..." before I even get to the username/password prompt.

At one point this worked but than after three times I get the same error message and can no longer access the database in multiuser mode. I have granted full rights to the Simply directory and files but alas to no avail. I suspect this may be a permission issue but I don't know enough about Simply's multiuser permissions.

My short term working solution is to put the database on a Windows share and let other PCs access however it does not let me use the Linux file server. Any insights out there?

bigshrugger
08-14-2006, 04:29 PM
Alright here is my problem. I have 2004 basic, single user and my computer shut off while my database was open last week. Now when I try and open up my file, I get the "other users" error and it won't let me back into the database. There must be a lock file somewhere that needs to be erased or something, but I have no clue where it would be. Any suggestions?

abala
07-20-2007, 10:53 AM
I am having the same problem, have you guys resolved the issue?.

Thanks