Company File Server setup

  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
Hi all,

I've been using Reckon on my own for a while but I have recently put on a new staffer in the office and she needs to access Reckon as well.  The data file is currently located on our OneDrive, which is mirrored locally on all computers (so there's a physical copy of the file on the two computers).  The problem with OneDrive is it doesn't allow us to work on the file at the same time, and we are having problems with OneDrive creating multiple copies so I've decided we need to set up the Company File Server to manage it.

The problem is I can't find any documentation on setting up the company file server.  I've uninstalled and reinstalled Reckon on the host computer with the company file server, but once that's done I have no idea what to do in order to get the second computer to access the data file from the host computer.

Can anyone direct me to some documentation that will guide me on how to get the second computer to access that data file?

Thanks
Photo of GoatyMcGoatBoat

GoatyMcGoatBoat

  • 966 Points 500 badge 2x thumb

Posted 4 weeks ago

  • 1
Photo of Rav

Rav, Community Manager

  • 45,800 Points 20k badge 2x thumb
Check out the info in this KB -

Installing, updating and configuring Reckon Accounts in Windows Server

There are more articles and help content in our KnowledgeBrowser, just add some keywords in the search box.
Photo of Bakaka Bakaka

Bakaka Bakaka

  • 192 Points 100 badge 2x thumb
Hi Goaty, depending on your version of Reckon (Premiere). Please note the followings:

- Host and Client workstations. 

Where the host is - the Reckon Accounts with Company File Server (during installation) should be installed there.

Where the client is - Reckon Account should (during installation) be installed there. 

Make sure, that the company data file is stored on the network where the clients workstations can have access to. Tip: Create a folder on the c-drive of the host PC (eg folder name: Reckon Company Data File)...put the data file inside that folder and share that folder so it is available on the network. 

Also, inside the your Reckon at the Host PC - Go to Reckon Account (at the host PC) and click "Company" tab and select "Set Up Users". Go ahead and set up the users (5 max) and create their passwords as well.

At the client PC - open Reckon Account (once installed at the client workstation/pc) and locate the company file where you have stored on the network (from that folder you have shared: Reckon Company Data File). Once you locate it, double click on the company file server, and a prompt dialog box should open and asks you for the user id and password...go ahead and enter the user and password and there you go.

Feel free to let me know if you have any further queries.

Cheers.
Photo of GoatyMcGoatBoat

GoatyMcGoatBoat

  • 966 Points 500 badge 2x thumb
Sorry Rav but that link doesn't help at all.  To be clear: I have two PCs in the office both running Windows 10, the first will act as the file server and a client and the second will act as a client only.  Both PCs need to be able to access the company file at the same time.  I do not have anything running Windows Server, although we will almost certainly set up a dedicated server in the future.

Bakaka Bakaka - Thanks for that, that's helped get started.  I've shared the company files folder and I can open the file from the second PC, however if the file is already open on the first PC then we get this error when trying to open it on the second one:



The host PC definitely has multi-user mode enabled:



EDIT: Also one more thing, on the second PC things seem VERY VERY slow, it takes upwards of two or three minutes to open the company file and get to the home screen whereas the host PC will do it in ten seconds or less.  Both PCs are similar spec, the host is slightly quicker but not enough to account for that big a difference.  Network is wired ethernet.

Any thoughts?

Cheers
(Edited)
Photo of GoatyMcGoatBoat

GoatyMcGoatBoat

  • 966 Points 500 badge 2x thumb
Hi again Shisir,

I've followed that KB article...

Solution 1:  Switch the file to multi-user mode
File is already in multi-user mode


Solution 2: delete the *.nd file
Done:


Solution 3:  give QBDataServiceUserXX Full Control permissions to the folder containing the company file.
Done:



Solution 4:  Verify that the Accounts Business network is properly setup
I went to the KB article there and followed everything, it didn't help.



PARTIAL SOLUTION:
Just to try and isolate the problem, I turned multi-user mode off on the Host PC and enabled it on the Client PC.... once the database server on the Client PC was running and Reckon was open, I was able to also open Reckon on the Host PC!

This method won't work in the long run though, as the Host PC (the PC that has the physical files on it) should be the one to host multi-user access.... the Host PC is my PC, and it needs to be the main host so that I can work from it anytime.  The second PC in the office, the admin PC, needs to be the Client in this situation.

I'm very confused as to why it will work in one direction, but not the other.
(Edited)
Photo of GoatyMcGoatBoat

GoatyMcGoatBoat

  • 966 Points 500 badge 2x thumb
Update
I've reset things back to the way they were (with the Host PC hosting multi-user access) and the problem has returned, however one interesting change is that the Client PC is now accessing the file from the network share much, much faster... no idea why, it just seems to be many times faster than it was.  

The error still persists though:
Photo of Shisir

Shisir, Employee

  • 1,946 Points 1k badge 2x thumb
Hi Goaty,
After deleting the .nd file, did you scanned the folder again, from database server manager (DBSM) , from the server PC? so it creates the new ND file?
If not Please repeat the step again.
1) delete the nd file from server/PC1.
2) scan the folder again using DBSM from the PC1.
3) Open the file from the PC1.
4) switch to MU Mode.
5) try open the file from the PC2.
Hope this works
Regards
Shisir
Photo of GoatyMcGoatBoat

GoatyMcGoatBoat

  • 966 Points 500 badge 2x thumb
Hi Shisir,

I've been through the process above to create the new ND file several times and unfortunately it still hasn't helped :(

Thanks
Photo of Shisir

Shisir, Employee

  • 1,946 Points 1k badge 2x thumb

Hi Goaty,

Let's take a step back and start from beginning again. As we have done quite different steps and may have confused ourselves.

  1. Create a new folder and copy your company file across to this new folder. (just a QBW company file) In your main PC.
  2. Make sure you can see/access this folder from  your 2nd PC.
  3. Open reckon Database server manager on the 1st PC. Scan the folder. Make sure the company file is listed. Then close it.
  4. This will create a new .ND file.
  5. Now open the Reckon Accounts in this 1st PC.
  6. Switch to Multi user mode.
  7. Go to file menu -> utilities and make sure it says "Stop hosting Multi user access". This means that your 1st pC is hosting. Your 2nd PC should never say this, it should say "Host Multiuser access", meaning it is not currently hosting.
  8. Now go to your 2nd PC, and try open the file from this new folder.
  9. If the issue persists, try disabling the antivirus and firewall on both PC and see if that works. If it works, it means you will need to configure your firewall. Please see this guide.http://kb.reckon.com.au/issue_view.asp?ID=220 you may want to speak with your IT for this.

Regards

Shisir