Version 19 of Microsoft Access

Updated 2015-02-12 06:46:18 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

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.