FreeBSD && remote MS ACCESS database

[Dan Nelson]

In the last episode (Nov 10), Matthias Apitz said:
> Is there any chance to read and update a remote MS ACCSESS database from
> FreeBSD 8-CURRENT, via ODBC?  Thanks in advance

With samba, wine, and a local install of Office, sure.  ODBC is a
programming API, not a networking protocol, so you need direct access to the
.mdb file.  MS Access is the only thing that can read .mdb files, so that's why
you need wine and a local Office install.

If you really need remote access to the data, move the tables into a
client-server database (mysql, postgres, etc) so you can get to them
directly from Unix, and use linked tables in your .mdb file so Access itself
will still work.

-- 
	Dan Nelson
	dnelson at allantgroup.com