FreeBSD && remote MS ACCESS database

Dan Nelson dnelson at
Tue Nov 10 15:18:05 UTC 2009

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

More information about the freebsd-questions mailing list