Go to Bottom

Moving the Order Manager Store Data File

In this Topic: ShowHide

For whatever reason (e.g., you get a new file server) you may need to move the Order Manager data file from one server or host computer on your network to another. Be sure to install the Order Manager and connect the new file server to your local network before moving the data file.

Moving the Data File

For an Access database

1. Determine the current location of your store data file, by pressing Ctrl+Shift+C from the Main Menu of the Order Manager.

2. Clear the table links by pressing Ctrl+Shift+L from the Main Menu. Click OK when prompted. Exit the Program. (Repeat this step on all machines running the Order Manager.)

3. Delete the c:\Stoneedge\SETI.ini file. (Repeat on all machines.)

4. Copy the data file to new location:

   1. If your data file is already in a shared folder on a network drive or server, simply copy the entire folder to the designated StoneEdge directory on the new file server. Make sure that the new folder is shared and users have adequate access to the folder. If the name of the StoneEdge directory on the new machine will be different than the name of the StoneEdge directory on the old machine, update the following system parameters settings in the Order Manager that enable users to configure the program integrate with their business operations. The Order Manager includes hundreds of System Parameters to do just that. To change a system parameter, go to the Maintenance Menu> Set System Parameters. to reflect the new location, as well: ArchiveLocation, NewOrderLocation,and SharedFileLocation.

   2. If you are just setting up a networked configuration of the Order Manager, copy the data file (e.g. MyStore.mdb), Custom Reports.mdb, the EmailTemplates folder, the NewOrders folder, and the DataArchives folders (optional) from the location in Step 1 to the designated StoneEdge directory on the new file server. Make sure that the new folder is shared and users have adequate access to the folder. If the name of the StoneEdge directory on the new machine will be different than the name of the StoneEdge directory on the old machine, update the following system parameters to reflect the new location, as well: ArchiveLocation, NewOrderLocation,and SharedFileLocation.

5. Rename the data file on the old file server (e.g. MyStoreOLD.mdb) to distinguish it from the data file copied to the new location.

6. For each workstation running the Order Manager:

   1. Launch the Order Manager.

   2. You will we prompted to open a new or existing store file the database used by the Order Manager that contains all order, customer, inventory and supplier records related to a given "store".. Click No to open an existing store.

   3. Navigate to the new location of the data file via My Network Places.

   4. Once the store has been opened, go to the Main Menu of the Order Manager and click the Switch Stores button.

   5. Select to mouse "left-click" on an object, usually a row in a table, in the context of Order Manager documentation the link to the old data file location and click Delete Link (this only deletes the connection to the old data file; it does not delete the actual file).

7. If you use  UPS WorldShip or other external shipping software, update the ODBC connections to reflect the new location of the data file.

Created: 1/30/12

Go to Top