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

From Free State Drivers
Revision as of 16:18, 15 January 2015 by Cvopicka (talk | contribs) (Created page with "__TOC__ 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 ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.

File:MacroError.png
Initial MS Access Error
File:MacroError1.png
Second MS Access Error


Fix

  1. Download the new macros. FPS699Macros.zip
  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