How do I share my MainBoss Basic database over a network?

First, we recommend that you install the MainBoss software on every computer where you think you will use MainBoss. While it is possible to store the software on one machine and execute that software from other machines on your network, you will get better performance if the software is installed directly on the computer where you're working.

Second, if you intend to access the database from more than two computers simultaneously, we recommend that the database be installed on a server version of Windows (e.g. Windows Server 2008) rather than Windows XP or Vista, or else on a network run by specific network software (e.g. Novell or a Unix/Linux system). If you attempt to store the database on a Windows desktop system (e.g. XP Professional or Vista Business), the system will either run very slowly when more than two computers are connected or else it will prevent connections entirely. However, you should be okay with XP Pro or Vista Business if you're only going to access the database from a maximum of two other computers.

Note: The rest of this document uses the term server for the computer that holds the MainBoss database. Other computers that will access the database will be called remove computers.

First Steps

Before trying to share access to a MainBoss database, you should make sure that the network is working in general.

• On each computer, start Windows Explorer. Go to the Network section of Explorer. Make sure that the server can "see" the remote computers and the remote computers can "see" the server. If they can't, consult your network documentation for information on establishing connections.
• All computers should have file sharing turned on. If you have a commercial firewall product (e.g. one that comes as part of an antivirus package), consult the software's documentation for how to allow file-sharing. If you're using the standard Windows firewall, follow these steps:
  1. On Windows Vista or Server 2008:
     • In the Control Panel, click Windows Firewall .
     • In the resulting window, click Change settings.
  2. On Windows XP or Server 2003:
     • In the Control Panel, click Windows Firewall.
  3. A window opens where you can make firewall adjustments. Go to the Exceptions section of this window.
  4. In the list, go to File and Printer Sharing. If the accompanying checkbox isn't already marked, checkmark it.
  5. Click OK to exit.
• All computers should have TCP/IP Internet protocols enabled. These are usually turned on by default during standard Windows installation. (TCP/IP isn't necessary to make file sharing work, but it makes connections more stable.)

Sharing the Database Folder

In order to make the MainBoss database accessible over the network, you must share it. To do this, login to the server computer under an account with Administrator privileges. Then follow these steps:

1. On the server computer, use Windows Explorer to locate the folder that contains the database (e.g. C:\MainBoss).
2. Right-click the folder. In the resulting menu, click Properties.
3. In the Sharing section of the resulting window:
   • On XP, click Share this folder, then click Apply, then OK.
   • On Vista, click Advanced Sharing. You will be asked to verify the action for security purposes. Then, in the resulting window, click Share, then Apply, then OK.

Next you must make sure that the computer has a user name and password for the person who wishes to access the MainBoss database folder. If you're connected to a network whose central server controls logins, this is already taken care of. Otherwise, follow these steps.

1. Login to a Windows account with Windows Administrator privileges.
2. In the standard Windows Start menu, right-click My Computer (on XP) or Computer (on Vista).
3. In the resulting window, click Manage. (On Vista, you'll be asked to confirm authorization. Do so.)
4. In the left hand side of the resulting window, expand the entry for Local Users and Groups.
5. In the resulting expansion, click Users.
6. Windows will show you a list of authorized users. If there isn't already an entry for the desired user name, right-click on Users and click New User.
7. Windows opens a window where you can enter user information. Under User name, put the login name you want to create.
8. Fill in Password and Confirm password with the desired password.
9. Fill in any other fields and/or select any options you wish, then click Create.
10. Close the "New User" window and the computer management window.

Now that you have made the database folder eligible for sharing and have created a user account for the person who will be sharing it, you must grant access to that folder for that user:

1. In Windows Explorer, locate the database folder again.
2. Right-click on the entry for the folder, then click Properties.
3. In the Security section of the resulting window, click Add.
4. In Enter the object names to select, enter the user name for the person who will be sharing the database.
5. Click Check Names.
6. Click OK.
7. Click OK again in the folder property window.

The user should now be able to access the MainBoss database folder over the network. To make it easy for the MainBoss software to use the database:

1. Using Internet Explorer, go to My Network Places (on XP) or Network (on Vista).
2. Local the computer that holds the MainBoss database folder.
3. Open the entry for that computer and locate the entry for the MainBoss database folder.
4. Right-click on the folder's Address line (at the top of the Explorer window), then click Copy (on XP) or Copy Address as Text (on Vista).
5. On the computer of the person who will be sharing the database, right-click on the desktop icon for MainBoss.
6. In the resulting window, click Properties.
7. In the Shortcut section of the resulting window, erase any contents of the Start in field and paste in the database folder address that you previously copied (e.g. by typing Ctrl+V).
8. Click Apply, then click OK.

You can now use this desktop icon to start MainBoss on the shared database folder.

Back to FAQ index