Re: FreeBSD && remote MS ACCESS database

In response to Dan Nelson <dnelson@xxxxxxxxxxxxxxx>:

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.

Not quite accurate. The .mdb format is supported by a number of Microsoft
products. In particular, MS offers an ODBC driver that read/writes the
.mdb files and makes it look like any other ODBC device. I don't know if
there's an equivalent for FreeBSD (or anything other than Windows).

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.

Connecting to a .mdb-based database remotely is fraught with peril. I've
seen dozens of .mdb databases corrupted over my years because some weird
file locking glitch or network glitch caused the files to become mangled.
Add to that the fact that an .mdb database has absolutely no security (to
the degree that any user could simply delete the entire thing) and I have
to agree with Dan's assertion that you'll be much better off, long run,
to move this onto a read DB server.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
_______________________________________________
freebsd-questions@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: FreeBSD && remote MS ACCESS database
    ... FreeBSD 8-CURRENT, via ODBC? ... With samba, wine, and a local install of Office, sure. ... and use linked tables in your .mdb file so Access itself ...
    (freebsd-questions)
  • Re: Read data from Access MDB file?
    ... was having trying to do this via ODBC. ... My mdb file is on a remote share, and I use an UNC path. ... That means it needs a valid local user account on the remote computer. ...
    (comp.lang.php)
  • Re: ODBC connection to mdb for MacIntosh
    ... As long as the computer has ODBC drivers for an Access database, it does NOT have to have Access installed. ... Office 98 and 2001 it was possible to control several different types of databases directly on a single Mac without having the application on the computer. ... No, you can not put the mdb file on a mac and connect to MS Access via ODBC because MS Access only runs in windows, not on a Mac. ... If you search Google on this topic about 2 years ago there was a complete thread in the Excel for Mac newsgroup about ODBC drivers. ...
    (microsoft.public.mac.otherproducts)
  • Re: DBI and DBD::ODBC and MS Access
    ... <ignoring questions I don't know the answers to> ... http or ftp) and apparently you can access a remote mdb file in this ... The server software doesn't matter for ODBC, ... the Access driver is freely available and distributable. ...
    (comp.lang.perl.modules)
  • Re: Converting from ADP to MDB/ODBC linked tables
    ... abandon Access when it's still perfectly usable. ... I don't like what I read about the limits of ODBC queries. ... Import Form1 into the newly created mdb file from my existing adp ... Bind the Form1 in the new mdb file to the linked View1 ...
    (microsoft.public.access.adp.sqlserver)