Recover the Access Database (IPS.MDB)

Note: Use this Solution with caution

 

Problem:

 

Idealpos does not start or is very slow when running, and the following errors may be in the IPSError.log:

20150607 15:32:17.311 0h 0m 31s Packet Failed to Process :ASTKTRN,308557,10,07 Jun 2015 07:32:08,201015,SAL,0,-6,166677,0,3,0,4,,Z *** Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

 

At another site, this tool was used to fix a problem where sales in POS to the Account tender was taking more than 30 seconds to finalize.

In 5.5, there may be a consline error, or the error Index LoginCode in table Clerks not found or Index CodePOSLine in table PendingSaleLines not found when running a Validation. (There is also a note that the 5.5 file can work with version 6.0).

 

This can also help when a conversion from 5.5 to 6.03 (or 6.03 to 7) fails.

 

Solution:

 

Use one of the following files, based on the version of Idealpos.

 

For version 5.5 (Builds 66 through 91 only):

IPSRecover5.50.0049.zip

For version 6.02:

IPSRecoverAccess6.02.exe.zip (Note: there is only one file required for this 6.02 utility).

For version 6.03:

IPSRecover603v2.zip

For version 7.1:

Idealpos Recover Access v7.1.zip

*Note: For version 7, you must first update the site to version 7.1 to use this utility!

For version 8 Build 8 and earlier:

Idealpos Recover Access v8b1-8.zip

For version 8 Build 9 and greater:

Idealpos Recover Access v8b9+.zip

For version 9:

Idealpos Recover Access v9.zip

 

Follow these instructions for versions 5.5, 6.03, 7, 8, and 9:

1. Copy the files in the archive into the correct folder:
   v7.1/v8/v9: \ProgramData\Idealpos Solutions\Idealpos
   v6: \Idealpos 6.0
   v5.5: \Idealpos 5.5
2. Close Suite.
3. Run the EXE, got to the File Menu and select Open Database. Select IPS.MDB (the actual database file). Agree to backup the file if asked.
4. The message Update Successful displays when the program has completed. Press File > Exit.

 

For the version 6.02 utility, follow these instructions:

1. Copy the file in the archive into the \Idealpos 6.0 folder.
2. Close Suite.
3. Run the EXE and select IPS.MDB (the actual database file). Agree to backup the file (V6 only).
4. The message Update Successful displays when the program has completed. Press File > Exit.

The Recover Access utility copies all the data from an existing IPS.MDB to the IPSDefault.MDB that you have in the folder. If the IPSDefault.MDB is out of date, this will not work.
To ensure that you are using the correct file, using the same version and build, load a clean database and choose New Database. Then rename the IPS.MDB that is created to IPSDefault.MDB and use this file.