Ability Database - Revision history

Dan Tobias: /* Sample files */

2020-02-12T00:04:44Z

‎Sample files

Dan Tobias at 22:44, 19 January 2014

2014-01-19T22:44:31Z

Dan Tobias at 22:42, 19 January 2014

2014-01-19T22:42:08Z

Dan Tobias: Created page with "{{FormatInfo |formattype=electronic |subcat=Databases |extensions={{ext|adb}} |released=1994 }} '''Ability Database''' (ADB) is the native format of the Database program in th..."

2014-01-19T22:40:21Z

Created page with "{{FormatInfo |formattype=electronic |subcat=Databases |extensions={{ext|adb}} |released=1994 }} '''Ability Database''' (ADB) is the native format of the Database program in th..."

New page

{{FormatInfo
|formattype=electronic
|subcat=Databases
|extensions={{ext|adb}}
|released=1994
}}
'''Ability Database''' (ADB) is the native format of the Database program in the Ability Office suite, though this program also supports the Microsoft [[Access]] (MDB) format.

Ability Database is a relational database supporting [[SQL]] queries, similar to a number of other database engines.

== Identification ==
Files appear to begin with the hex bytes <code>00 01 00 00 53 74 61 6E 64 61 72 64 20 4A 65 74 20 44 42 00</code>, which includes the [[ASCII]] string "Standard Jet DB".

== See also ==
* [[Ability Office PhotoPaint]]
* [[Ability Write]]
* [[Ability Spreadsheet]]

== Sample files ==
* [http://www.dan.info/sampledata/TESTDB.ADB TESTDB.ADB] - Test database

== Other links ==
* [[Wikipedia:Ability Office|Wikipedia article on Ability Office]]
* [http://www.ability.com/ Ability Software site]

@@ Line 7: / Line 7: @@
 '''Ability Database''' (ADB) is the native format of the Database program in the Ability Office suite, though this program also supports the Microsoft [[Access]] (MDB) format.
-Ability Database is a relational database supporting [[SQL]] queries, similar to a number of other database engines.
+Ability Database is a relational database supporting [[SQL]] queries, similar to a number of other database engines. The presence of the string "Standard Jet DB" in the file headers indicates the possibility that this format is derived from the Jet format on which MS Access was also based.
 Text strings appear, as in the other Ability Office programs, to be stored in 16 bit [[Unicode]], perhaps [[UTF-16]].

← Older revision		Revision as of 22:42, 19 January 2014
Line 8:		Line 8:

	Ability Database is a relational database supporting [[SQL]] queries, similar to a number of other database engines.		Ability Database is a relational database supporting [[SQL]] queries, similar to a number of other database engines.
		+
		+	Text strings appear, as in the other Ability Office programs, to be stored in 16 bit [[Unicode]], perhaps [[UTF-16]].

	== Identification ==		== Identification ==

@@ Line 20: / Line 20: @@
 == Sample files ==
-* [http://www.dan.info/sampledata/TESTDB.ADB TESTDB.ADB] - Test database
+* [https://www.dan.info/sampledata/TESTDB.ADB TESTDB.ADB] - Test database
 == Other links ==
 * [[Wikipedia:Ability Office|Wikipedia article on Ability Office]]
 * [http://www.ability.com/ Ability Software site]