references.txt

//-*- coding: utf-8 -*-

Bra att känna till om Access/Jet-DB:

https://web.archive.org/web/20221006153557/https://support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671

https://web.archive.org/web/20210507203758/https://stackoverflow.com/questions/4551112/access-database-limit-keyword

https://web.archive.org/web/20221229152352/https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

Schema of mdb-file can be found using jet-tool by himselfv
https://github.com/himselfv/jet-tool/releases/tag/0.6b
\tmp\Jet.exe schema -f foo.mdb >schema.txt
\tmp\Jet.exe dump -f foo.mdb >dump.txt

Dump existing (empty/new) database to txt and back (tom.mdb -> dumptom.sql -> jette.mdb):
\tmp\Jet.exe dump -f tom.mdb --all >dumptom.sql
\tmp\Jet.exe exec -f jette.mdb -new --db-format jet20 <dumptom.sql

Tool to explore a mdb file: http://www.alexnolan.net/software/mdb_viewer_plus.htm

Or https://sourceforge.net/projects/jetsqlconsole/
More tools may be available via
https://en.wikibooks.org/wiki/JET_Database/Manipulation_tools