Common solution to error messages in EPOS - ReplaceMDE.bat

[G.W.Green]

The simple solution below will solve the following error messages you see in EPOS:

You can fix the errors listed below by replacing the Checkout.mde file.

Errors:

• This database is in an unexpected state; can't open. This database has been converted from a prior version of by using the DOA compact Database method instead of the convert database.
• "Error initialising local variables", then "3078The Microsoft Jet Engine cannot find the input table or query 'Local_tblSetup_Global'.
  
• "No Users on Database"
  
• "Unrecognized database format"
  
• ‘Copy Data from Server' not shown in (sales screen) Menu F10 even though it’s been selected in Security.
• 'ParentIdName' is not an index in this table.
  
• "The Microsoft Jet Database Engine……………..

Solution:

1. Close SellerDeck EPOS down on all PCs.
2. On your PC double click "My Computer" or "Computer"
3. Browse to C:\checkout\
4. Find the file called "ReplaceMDE.bat" and double click on it (Screenshot below).
   
   
   
   
5. A small window will briefly open and close again. The error message will now be solved.
6. Restart EPOS and log on with your usual code.

Please note: if you are using EPOS network, you will need to reconnect your tills to the main database PC:

1. In SellerDeck EPOS, go to Setup | This Till | "Connect" tab.
2. Next to "Path to Data" is a "Connect" button, click this button, it take take upto 5 minutes for the connection to finish.
3. Repeat this for "Connect Trans", "Connect Orders", "Connect Stock" and "Connect ZRead"

Please note: running replace.bat will also clear the list of tickets you have built up in the "Tickets" screen in EPOS, you will need to build this list up again.

Please note: This quick solution was only added into EPOS 3.10 onwards. if you are using a previous version of the software, the problem will also be resolved by upgrading to the latest version - click here to download the latest version.