1. Home
  2. Program Maintenance
  3. Moving an MS Access Store Data File

Moving an MS Access Store 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 SEOM.
  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 SEOM.)
  3. Delete the c:\Stoneedge\SETI.ini file. (Repeat on all machines.)
  4. Copy the data file to new location:
    • 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 to reflect the new location, as well: ArchiveLocation, NewOrderLocation,and SharedFileLocation.
    • If you are just setting up a networked configuration of SEOM, copy the data file (for example, 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.
  1. Rename the data file on the old file server (for example, MyStoreOLD.mdb) to distinguish it from the data file copied to the new location.
  2. On each workstation running SEOM:
    • Launch SEOM.
    • You will be prompted to open a new or existing store file. Click No to open an existing store.
    • Navigate to the new location of the data file via My Network Places.
    • Once the store has been opened, go to the Main Menu of SEOM and click Switch Stores.
    • Select 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).
Updated on June 4, 2019

Was this article helpful?

Related Articles