mdb-ver(1)

1mdb-ver(1)           Executable programs or shell commands          mdb-ver(1)
2
3
4

NAME

6       mdb-ver - Return the format of a given MDB database.
7

SYNOPSIS

9       mdb-ver database
10       mdb-ver -M
11
12

DESCRIPTION

14       mdb-ver is a utility program distributed with MDB Tools.
15
16       It will return a single line of output with 'JET3' for those files pro‐
17       duced in Access 97 format, 'JET4' for those produced by Access 2000, XP
18       and  2003,  'ACE12'  for  those produced by Access 2007, or 'ACE14' for
19       those produced by Access 2010.
20

OPTIONS

22       -M     Prints the version of MDB Tools itself instead of the MDB file.
23

NOTES

25       Access changed its format between Jet 3 used in Access  97  and  Jet  4
26       used  for Access 2000 and XP. The nature of the changes included moving
27       the page size from 2K to 4K and added support for  unicode.  MDB  Tools
28       actively supports both formats. Newer version are very much like Jet4.
29

ENVIRONMENT

31       MDB_JET3_CHARSET
32              Defines  the charset of the input JET3 (access 97) file. Default
33              is CP1252. See iconv(1).
34
35       MDBICONV
36              Defines the output charset. Default is UTF-8. mdbtools must have
37              been compiled with iconv.
38
39       MDBOPTS
40              semi-column separated list of options:
41
42              ·  use_index
43
44              ·  no_memo
45
46              ·  debug_like
47
48              ·  debug_write
49
50              ·  debug_usage
51
52              ·  debug_ole
53
54              ·  debug_row
55
56              ·  debug_props
57
58              ·  debug_all is a shortcut for all debug_* options
59

HISTORY

61       mdb-ver first appeared in MDB Tools 0.4.
62

AUTHORS

68       The mdb-ver utility was written by Brian Bruns.
69

BUGS

71       mdb-ver does minimal checking on the validity of a file. It is possbile
72       for it to misidentify a non-MDB file.
73
74       mdb-ver does not recognize Access 2.0 (Jet 2).
75
76
77
78MDBTools 0.7.1                  29 January 2020                     mdb-ver(1)