Version 17 of Microsoft Access

Updated 2015-02-12 06:45:40 by goog

Microsoft Access is a database system

See Also

a form for Access Database

migrating ms access to other databases using XML

Tcl Programs for Access

TDBC

Tclodbc

SQL Relay

Other Programs for Access

MDB Tools

a package of libraries and utilities that allow Unix-like systems to natively read Microsoft Access database (MDB) files. Dissects access files. I believe that it offers an API which can be pretty easily wrapped and though it is not completely stable (according to traffic on their mailing list) seems to do a pretty good job. They also offer a rudimentary ODBC driver."

Description

Jet is Access's persistence back-end, and the aspect of Access most likely to interest Tcl developers immediately. Windows has bundled Jet for several years now--write a Jet-dependent application, and it should work fine on any Windows host since Windows 95 (?).

In 2002, Jet was renamed to MSDE. [L1 ] might explain more. It's also called "MDB" and "MSDB".

RS: A simple way to interact with Access is via CSV files (see also the links there) - plain text files with comma-separated values (in German locale, Access does not allow to use commas though, because it is considered decimal separator, so use semicolons instead; Excel accepts commas though...

no

Misc

etdxc: Just a quick note. When using tclodbc to work with Access memo fields, if you insert a record which contain a memo field that contains a large amount of data, you may get a problem rereading it. TclOdbc returns all the data associated with the memo, spurious or otherwise. In a rush (as always) I found the easiest solution is to store the memo as a two element list (or as two seperate fields), index 0 contains an integer 'size' of the memo and index 1 the memo itself. Use [lrange] to extract the actual stored text.

Of course there may be a (lot) better method. If so, please let me know.

---