Contents - Index - Previous - Next

Database Setup for Multiple Companies

Complete the following procedures for multiple company database setup:
1. Close out of eTEK™ Accounting application if it is currently open.
2. Open Windows Explorer.
3. On each workstation create subdirectories (folders) within the Program Files\eTEKAcct\ (or similar) for each company that will be created.  From the File Module choose Create Directory. We recommend that each subdirectory be the individual company name.  For example, Program Files\eTEKAcct\CoABC.
4. On each workstation, within each company's subdirectory, place a copy of eTEKCode.accdb (or similar).  
5. On the server, create an eTEKAcct directory.  Create subdirectories for each company.  Within each company's subdirectory place a copy of eTEKData.accdb (or similar) and eTEKErr.accdb (or similar). Note: If the General Ledger Chart of Accounts or People, Places, Things information is similar for multiple companies, you may want to enter this information before copying the databases into separate subdirectories.  Doing this will prevent duplicate data entry.
6. On each workstation, make copies of the icon "eTEK™ Accounting  " in the Start Module. Rename each copy to represent the company name.  
7. Redirect the target of the icon to point to the individual company's eTEKCode.accdb (or similar). The target line below might look something like this: "C:\Program Files\eTEKAcct\CoABC\eTEKCode.accdb (or similar)".
8. Open the first of the new companies using your newly created icon.  When the screen prompts you to Select Database Attachments, change the path and file names for each file.  Pressing the binoculars by each file name line will invoke a browse window that will allow you to select the correct path and name for each file.  When the correct databases are selected, press the Attach button. 
9. After the attachment process is finished and the Main Module is displayed, exit the program.  
10. Proceed to the next company and repeat steps 7 through 9.  
11. After all the companies have been setup and all the procedures outlined above have been completed, the final check will be to go into each of the new companies through your new shortcut icons.  At the main eTEK™ Accounting Module, go to System Utilities under the Action tab and choose Reattach Accounting Data and Error Log Tables.  Check the file names and paths on the screen.  If they are correct then choose Cancel.  If the information was incorrect then you will need to redo steps 7 through 9. Note: With respect to directory names and file locations, we recommend that all workstations be setup in the same manner for consistencies sake. If your computers are networked so that you can "see" the other workstations on your network, you can copy all the new company folders containing eTEKCode.accdb (or similar) off of your workstation into the eTEKAcct directories on all the other workstations.