You are here: HOME  >>>  Excel Invoice Manager

Networking

Excel Invoice Manager Pro and Enterprise editions support networking. This simple tutorial goes through the steps for sharing database(s) between multiple computers.

Let's say we have two computers. They are all running Windows XP Pro. ComputerA will host the shared database file, and computerB will connect to the database on ComputerA. These two computers are locally networked.

  1. Create a folder named DB on ComputerA.
  2. Right click the DB folder and select Properties.
  3. Switch to the Sharing tab.
  4. In the Network sharing and security section, check the option Share this folder on the network and Allow network users to change my files.

    5. invoice network
    (Click to enlarge)

  5. Click OK.
  6. Store the database file in the DB folder, or create a new database file in the DB folder.
  7. On ComputerB, open My Network Places.
  8. Click menu Tools -> Map Network Drive.

    9. invoice network
    (Click to enlarge)

  9. Choose a drive letter, such as S:.
  10. Click Browse.
  11. Browse to and select the shared DB folder on ComputerA.

    12. invoice network
    (Click to enlarge)

  12. Click OK.
  13. Click Finish to close the Map Network Drive dialog box.

    14. invoice network
    (Click to enlarge)

  14. Open My Computer. Make sure there is a drive "S:" and that you can open it.

    15. invoice network
    (Click to enlarge)

  15. Open your invoice template. Click the Settings button on the Invoice worksheet.
  16. Switch to the Database tab.
  17. Click Open Database.
  18. Browse to and open the shared database.

    19. invoice network
    (Click to enlarge)

    Note: Make certain that you are opening the shared database via its mapped driver letter (i.e. S:), and not the computer name in My Network Places, or the system will not be able to find the database file and will display the following message:

    invoice network
    (Click to enlarge)

  19. On the Invoice worksheet, below the Current Database label you will find the name of the database which is currently connected.

    20. invoice network
    (Click to enlarge)

  20. Save the template once. This insures the template will connect to the specified database automatically next time you open it.
Excel Invoice Manager Free Download and Try (4.17 MB)
Learn More Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Before Using Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Adding Extra Rows to Invoice Body Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement More Topics Registration and Services Reference
Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer How Do I Replace the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices
Home Contact Us Privacy Link to Us
copyright © Office-Kit.com, all rights reserved