As installed, ThumbsPlus creates a database called Thumbs.tpdb8 using the Microsoft Access JET format. However, ThumbsPlus uses
ODBC to communicate with its database, so other database formats
can be used instead. (Note: Pro,
Home Network and Network licenses only; a Standard license
can only use the default JET database.)
Client/server databases offer greatly improved performance when sharing a database in a network environment, and the capability to have
databases larger than the JET 2 gigabyte limit.
Upgrading from version 7: Use the menu selection Database - Advanced - Convert client/server to convert the database from the prior format.
Creating a new database: The following table has SQL scripts that you can download to create a new database of the desired format.
Note that you should open the script in a text editor to modify it for your specific database and to select the desired thumbnail size and other constants. You may want to use the tools provided with the database to create it and control the locations and names of the database data and log files. Also you may want to change the INSERTs to the ThumbsPlusDatabase table to match the desired thumbnail size, compression, and other attribute.
Other databases may be supported in the future. If you have a specific request, please submit a problem report.
1 Other versions may work; these are the versions with which we
have most recently tested ThumbsPlus and the scripts.
2 Right-click and select Save Link As or Save Target As to save the script
to your computer. Use notebad to make changes, then command-line or query tool for your
database to execute it.
Some databases may require that you download
a separate package for ODBC support, and you will need to configure
an ODBC data source for connecting to the database. The ThumbsPlus
version 7 Manual has information on creating an ODBC
data source, in the SQL Server Administration section.