This article applies only to systems using the default Microsoft Jet database. Skip this article when using the MS SQL Server database engine.

 

Amigo Pos uses a single Microsoft Jet database file to store system and sales data. In addition, each pos station automatically creates a locally cached copy of the database to improve performance and speed network access. The local database is refreshed when Amigo Pos is started and at a predefined interval during user login. The database should be refreshed after modifying system settings or updating menu or employee data. When exiting Back Office, a dialog will appear prompting the user to force a database update at the next user login on each pos station, enabling the user to override the predefined database update interval by forcing an immediate update.

 

New users should review the following topics before continuing:

 

 

During installation, the setup program will prompt the user to either create a new database or select an existing database. If Amigo Pos is being installed for the first time, select Create a new database and specify a database name and writable directory. MS Windows Vista users should select a public shared folder, i.e. C:\Users\Public\Documents. MS Windows XP users should select a public shared folder, i.e. C:\Documents and Settings\All Users\Documents.

 

 

 

If Amigo Pos has been previously installed on the local machine, a registry entry containing the database location already exists. Choose Select an existing database and click Next. Select the location of the database. The database location may be located on the local hard disk or on a mapped network drive.

 

 

 

The path to the database created during installation is found by logging in to back office and navigating to Program Setup - Database Setup

 

 

 

---

Page url: http://www.amigopos.com/help/html/index.html?database_management.htm