|
External database page in the configuration |
Top Previous Next |
|
You'll find descriptons of window elements below.
Accounts database file path Enter path to the database file, or use the browse button to locate it. Remember to use the provided database template called CafeSuite.mdb. You can find it in the installation directory, usually C:\Program Files\CafeSuite\CafeSuite.mdb. Of course you can move the file it to some other location for your convenience. DSN settings DSN stands for Data Source Name, it's a mechanism which allows other applications (like MS Excel or MS Access) to connect to the data source, in our case - CafeSuite accounts database. By installing DSN, you can easily access accounts database from other applications that support this technology. Press the Install DSN button to install DSN in the system. You can always uninstall it using the Uninstall DSN button. The DSN will be visible under the name given in the Database name field. You can also set username and password for the database. Use the Data Sources(ODBC) applet in the Control panel to change options of the installed DSN. Database operations Import accounts from database - use this button to import accounts from the external database. Export accounts to database - use this button to export accounts to the external database. Export sales to database - use this button to export sales data to the external database. Import accounts from database when modified - select this option to update CafeStation's internal account database every time a modification in the external database is detected. Automatically export accounts to database - select this option to have the internal accounts database exported evey time a change is made. Automatically export sales to database - select this option to have the internal sales database exported evey time a change is made. See also |