Backup MS Access Data File

Contents of this Topic: ShowHide

Overview

• The information contained in your store data file the MS Access or SQL database that contains the users order information and program preferences. It does not contain Reports, which are housed in the Monsoon OMS program file (MS Access database).(s) is unique to your Web store or stores.

• It contains all of your customer, order, and supplier vendor records in addition to all of the system settings you entered in System Parameters settings in Stone Edge that enable users to configure the program integrate with their business operations. Stone Edge includes hundreds of System Parameters to do just that. To change a system parameter, go to the Main Menu > Settings > System Functions > Set System Parameters..

• If a store data file the MS Access or SQL database that contains the users order information and program preferences. It does not contain Reports, which are housed in the Monsoon OMS program file (MS Access database). is lost or becomes corrupted, you will need to restore a backup copy to resume processing.

• The program provides the ability to create backup copies of MS Access store data files from the Quick Clicks>Backup Data File or Main Menu>Settings>Data Functions>Backup Data File.

• Those using an SQL database as their store data file must use SQL Management Suite tools to create a backup copy of their store data file, OMS cannot backup an SQL database at this time.

• OMS does not provide an automated restore utility for MS Access or SQL databases. You must manually restore and/or rename the backup copy of an MS Access data file to the correct production file name.

• It is worth investing in third-party backup and recovery software to ensure the safety of these and other critical files, such as the Email Templates folder and Custom Reports database, which should also be backed up on a regular basis. Many products are able to schedule backups to run automatically.

• Stone Edge Technologies Inc. strongly recommends that you make daily backups of your data file(s). We can replace your program file The MS Access database that contains the Monsoon OMS application code. This database does not contain the user's order information, which is housed in the Store Data File. The program file name begins with SEOrdMan* and has the extension of .mdb. (e.g. SEOrdMan.mdb), but we cannot replace your store data file(s)!

• Sending a copy of critical files off-site is also highly recommended, to provide the ability to recover from any physical disasters affecting your store or warehouse.

Description of the Backup MS Access Data File Function

MS Access Data Files

• The Backup Data File function places a copy of the current store’s data file in the archive directory specified by the system parameter ArchiveLocation.

• The backup file is named StoneEdgeDataBUyyyymmdd.mdb, where "yyyymmdd" is the date the backup was performed. If a file with that name already exists (if another backup was performed earlier in the same day), the program adds a hyphen and a number to the name, for example, StoneEdgeDataBU20050214-1.mdb.

• The program does not delete old backup files automatically. Therefore, you may want to delete old backup copies from your archive directory every month or so to save disk space.

Making a Back Up Copy of an Access Data File

1. Make sure all users have exited the program on all workstations. Any shipping applications that access the store data file must also be closed, such as UPS WorldShip or FedEx ShipManager.

2. Launch the program on one workstation and log-in, if security is enabled.

3. Go to Main Menu > Settings > Data Functions > Backup Data File or select to "left-click" the mouse on an object, usually a row in a table, in the context of Monsoon OMS documentation Backup Data File from the Quick Clicks.

4. The program prompts the user for confirmation prior to starting the backup process.

   

    

5. Click OK to continue.

6. If the program is not able to initiate a backup at this time, it displays a ist of actions to take prior to re-attempting the backup. Click OK, perform the actions and try again.

   

    

7. When the backup is successful, the program displays a message box that tells you the name of the backup file.

   

    

8. Click OK  to conclude the process.    

Restore a Backup Copy of an Access Data File

1. Delete or rename the current copy of OMS ’s data file (the bad file that you want to replace). For example, if your store’s data file is called MyOrders.mdb, rename it to MyOrdersBadData.mdb.

2. Go to the diirectory specified in the parameter ArchiveLocation and copy the backup data file that you want to restore. (Right-click the file and select Copy)

3. Paste the data file you just copied into the directory where the store’s data file is located. (Right-click in the folder and select Paste)

Note: Do NOT delete the copy of the backup data file in the archive directory. You may need to restore from it in the future.

4. Rename the backup data file you pasted in step 3 to the original name of your store’s data file, in this example,  MyOrders.mdb. (Right-click the file and select Rename. Change the name of the file in the highlighted box and press Enter.)

Note: Follow these basic directions to restore copies of your Custom Reports.mdb and Email Templates folder as well, if it ever becomes necessary.

Created: 2/27/12

Revised: 11/7/12

Published: 04/14/16