Error when creating a view in a RequisitePro project: Data Provider or Other service returned an E_FAIL status

Resolving The Problem

Compact and repair the Access database usually resolves the issue.

REPAIRING AND COMPACTING USING MICROSOFT ACCESS:

1. Make sure that all users have closed the project.
2. Launch Microsoft Access.
3. Cancel out of the initial dialog box, which asks whether you want to open or create a database. Access will start.
4. Go to Tools > Database Utilities > Compact and Repair Database. In the Compact Database From window, browse to the project MDB file, then click on Compact.
5. In the Compact Database Into window, select the same database. Click Save.
   Note: The existing database can be used as a backup, if instead of using the original MDB file name and overwriting the original database, a new name is used in the Compact Database Into window (such as db1.mdb). Before opening the project in RequisitePro, and after completing the repair and compact process, the old database will need to be renamed to a different name (such as project.bak) and the newly compacted database will need to be renamed to the name of the original database (such as projectname.mdb).
6. A warning will appear asking if the database should be overwritten (see Note, above). Click Yes.
7. When it completes, it will go back to the blank Microsoft Access screen.
   
   The database has been compacted and repaired successfully.