|
Open you SQLLink.mdb database on the server in Microsoft Access. Using the menu commands within Access select File > Get External Data > Link Tables.
Select Files of Type ODBC Databases ()
Select the Machine Data Sources Tab.
For Business Vision versions 6 and below, click on the following 9 tables to select the required tables:
|
|
|
1
|
Cust Details
|
2
|
GL Chart
|
3
|
GL ChartFull
|
4
|
SuppDetails
|
5
|
TerrCode
|
6
|
TaxTable
|
7
|
CTRLPeriods
|
8
|
CTRLShipMethods
|
9
|
CTRLTerms
|
For Business Vision version 7, click on the following 6 tables to select the required tables:
|
|
|
1
|
ADDRESS
|
2
|
BVCustomer *
|
3
|
BVVendor *
|
4
|
GL_CHART_OF_ACCOUNTS
|
5
|
GL_GROUPS
|
6
|
MULTICURRENCY
|
* indicates a view, not a table. The BVCustomer and BVVendor views must be created while setting up the link; the views contain all of the fields from the BV Customers and Vendors tables respectively. When asked to specify the primary key when linking the views to SQLLink, use the Customer/Vendor Number. The reason why the views are created and linked instead of linking the actual BV tables is because Microsoft Access cannot link directly to the tables due to the large number of indexes. The views circumvent this limitation.
Click OK. In Access you should see the following Business Vision tables on the Table View form. You can double click on any table to see your BV data
Warning: Never directly alter any data in BV through the Access Tables! You could corrupt your data.
It is recommended you copy your Business Vision Data to a separate directory and create a new company for testing purpose.
Refer to section on Update Accounts to import Customers, Vendors or GL Accounts
|
