* System - Attach Tables

Overview of How Data is Stored In OneSource

• The OneSource application file (OneSource.mdb) does not hold any user data (such as Customers, Invoices, Inventory Items, etc).  OneSource actually stores data in one or more separate database files, using one of these 3 configurations:
• Single Company Data File: This configuration is most commonly used for companies that have less than 1 GB of data.  This method stores all data in 1 MS Access (.mdb) database - usually named after your company name.  This file is typically stored in this location: C:\OneSource\Data\.  You can use the Attach Tables screen to browse for and attach to the OneSource.mdb Company Data File.
• Distributed Set of Company Data Files: This configuration is most commonly used for companies that have between 1.0 to 2.0 GB of data.  This configuration has a primary 'Company Data File' as well (like the method above).  However, when that data file begins to grow too large, then turning on the Distributed Set of Company Data File option (in the Company Setup & Preferences) will automatically create 13 additional .mdb database files and will then 'distribute' (move) several of the most common (largest) tables into these 13 new database files.  (After distributing most of the data into these new database files the problem with the original Company Data File is solved).  In addition to the Company Data File, these 13 additional data file are also typically stored in this location: C:\OneSource\Data\ and usually are all named with the same naming convention--each starting with os... You can use the Attach Tables screen to browse for and attach to the OneSource.mdb primary Company Data File as well.  This will also automatically attach the rest of the distributed data files to the OneSource.mdb file as well.
• Distributed Set of Company Data File + SQL Server: Very similar to the Distributed Set of Company Data Files option, this option also uses Microsoft SQL Server to store a few of the tables (such as the Sale Order table).  In this configuration you must use the Data Source screen to properly attach the tables to your OneSource.mdb application file. 

How to Open the Attach Tables screen

You can open the Attach Tables screen using any of these methods:

• Click File > Link to Company Data File (*.MDB or *.MDE) > then click Yes when prompted. 
• Or, On the OneSource Login screen click the Relink to a Different Company Data File button.
• Or, when opening OneSource, if the data file cannot be located, the Attach Tables screen

Using the Attach Tables screen

• After opening the Attach Tables screen, you can link to a Company Data File following these steps:
• Click the Browse... button
• Navigate to your Company Data File (Note: Your company's data file is usually named something similar to the name of your company, such as XYZData.mdb and is usually stored in the C:\OneSource\Data folder).
• After locating your Company Data File click on it and then click Open.