FPS:Database.ini

From Free State Drivers
Jump to navigation Jump to search

This applies to FPS versions <= 6.99. For FPS versions >= 7.00 please see Database.dsn

The Database.ini file is created by FPS MS Access databases when the Start button is pressed. This file stores the location of the database to be processed by FPS.

Limitations

There are several limitations to the Database.ini system

  • Only MDB and not ACCDB files are compatible
  • The path can contain no '.'
  • difficult to attach to non MS Access databases

Format

Example: Correct

Assuming the database of interest is C:\FPS\Data\Puget\PugetA.mdb

|DBQ=C:\FPS\Data\Puget\PugetA.mdb

Example: '.' (FAIL)

Assuming the database of interest is C:\FPS.Folder\Data\Puget\PugetA.mdb

|DBQ=C:\FPS.Folder\Data\Puget\PugetA.mdb

FPS will process this to be C:\FPS.mdb

Example: ' ' (Success)

Assuming the database of interest is C:\FPS Folder\Data\Puget\PugetA.mdb

|DBQ=C:\FPS?Folder\Data\Puget\PugetA.mdb

Note the '?' that replaces all ' '. FPS will convert those back to the proper format internally.