Error: The expression you entered has a function name that FBRI FPS Database can't find.

From Free State Drivers
Jump to navigation Jump to search

Only in the latter part of 2012 has this issue popped up. Microsoft has changed the security of some functions that had worked in the past this can be fixed with an update of the FPS Macros in the database.

Error Images

The following are screen shots of the error that you will encounter.

Initial MS Access Error
Second MS Access Error


  1. Download the new macros.
  2. Extract the archive
  3. Open your database that needs repair
  4. Navigate to the Macros listing
  5. Delete FPS Macros
  6. Import macros from above extracted database
    1. Select Import
    2. navigate to the extracted database
    3. select FPS Macros
    4. Complete import
  7. Compact and repair your fixed database