FPS:Database.ini
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.
Contents
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.