Select Store

Contents of this Topic: ShowHide

Overview

Users may have more than one business or web store that they want to manage with OMS , and therefore may have multiple store files.

The Switch Stores button on the Main Menu is the mechanism which allows a user to switch from one store file the database used by Monsoon OMS that contains all order, customer, inventory and supplier records related to a given "store". to another, without exiting the program. When this button is clicked, the user is presented with a list of previously opened store files from which to choose. If the desired store file is not listed, use the Browse button to navigate to it.

It is also possible to choose from a list of System or File DSNs on the current workstation. System DSNs are more common.  

Deleting a link to one of the store files in the list does not delete the file, only the link to it.

When the Switch Stores button is clicked, the Select to "left-click" the mouse on an object, usually a row in a table, in the context of Monsoon OMS documentation Store/Select Store to Open screen synonymous with the Microsoft Access Form object or graphical user interface (GUI) appears. Follow the instructions in this topic to learn how to switch between different store files.  

The Switch Stores process does not involve the creation of a new store file. To create a new store or data file, go to the Main Menu>Settings> System Functions and select Create New Store. Refer to the Knowledge Base for more information.

Description of the Screen

Delete Link Button

• select a store definition in the list of previously opened store files and click this button to permanently remove it from the list

• this does not delete the file, only the link to it; the file will not re-appear in the list unless it is selected via the DSN Data Source Name - associates a specific SQL Server, driver, and database together in a connection string used to access the data. buttons or the Browse button.  

Show:

Previously Opened Stores

1. • this is the default view when this screen is opened

   • the stores that have been opened recently are listed in the lower half of the screen

System DSNs Button

1. • use this button to select the store file from a list of System DSNs that have been defined on this workstation

File DSNs Button

1. • use this button to select the store file from a list of File DSNs that have been defined on this workstation

Open Button

• when a previously viewed store is selected from the list displayed on this screen, click this button to open that store file

Browse Button

• if the desired store is not listed at the bottom of this screen, use this button to navigate to its location and open it

Cancel Button

• to terminate the request to switch stores, click this button to exit this screen

List of Stores

Store Name Column

1. • this column displays the name of OMS store

File Location Column

1. • this column displays the path to the particular store file

Switching Stores

1. Go to the Main Menu and click the Switch Stores button. This button is only visible if the system parameter AllowSwitchStores is set to TRUE.

2. The Select Store to Open screen opens.

3. Double-click the appropriate store or select it from the list and click [Open].

4. If the store you want to open is not listed:

SQL Store File

1. 1. click the [System DSNs] button and select the appropriate DSN for the desired store file

   2. skip to step 5

MS Access Store File

3. 1. click the [Browse] button to navigate to its location.

   2. the Select data .mdb for your web store screen opens

   3. navigate to the location of the store file of your choice

   4. double-click the appropriate .mdb file or select it and click the [Open] button

5. If OMS 's security system is active, the user will be prompted to enter their user name and password for the new store file.

6. OMS displays a confirmation message when the new store is open.

7. Click [OK] to finish the process.

Created: 1/26/11

Revised:

Published: 04/14/16