From owner-freebsd-questions@FreeBSD.ORG  Tue Nov 10 17:02:13 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 15091106566B
	for <freebsd-questions@freebsd.org>;
	Tue, 10 Nov 2009 17:02:13 +0000 (UTC)
	(envelope-from rodperson@rodperson.com)
Received: from www6.pairlite.com (www6.pairlite.com [64.130.10.16])
	by mx1.freebsd.org (Postfix) with ESMTP id E8DC88FC0A
	for <freebsd-questions@freebsd.org>;
	Tue, 10 Nov 2009 17:02:12 +0000 (UTC)
Received: from atomizer (pool-173-71-189-135.pitbpa.fios.verizon.net
	[173.71.189.135])
	by www6.pairlite.com (Postfix) with ESMTP id 322A9BA5C;
	Tue, 10 Nov 2009 11:36:14 -0500 (EST)
Date: Tue, 10 Nov 2009 11:36:52 -0500
From: Rod Person <rodperson@rodperson.com>
To: Matthias Apitz <guru@unixarea.de>
Message-ID: <20091110113652.56a68963@atomizer>
In-Reply-To: <20091110150158.GA6500@current.Sisis.de>
References: <20091110150158.GA6500@current.Sisis.de>
X-Mailer: Claws Mail 3.7.2 (GTK+ 2.16.6; i386-portbld-freebsd8.0)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: FreeBSD && remote MS ACCESS database
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 10 Nov 2009 17:02:13 -0000

On Tue, 10 Nov 2009 16:01:58 +0100
Matthias Apitz <guru@unixarea.de> wrote:

> 
> Hello,
> 
> Is there any chance to read and update a remote MS ACCSESS database from
> FreeBSD 8-CURRENT, via ODBC? Thanks in advance
> 
> 	matthias

If you are familiar with python you could use py-odbc to read the access
.mdb file as a normal database.

A connection string of an Acess 2007 db without a password would look like this, 
where fileName is the complete path and file name of the access mdb file.

cntString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=%s; User Id=admin;Password=;" % (fileName)

I've not tried it over an internet connection, though.


-- 
Rod Person
http://www.rodperson.com
  
Religion is what keeps the poor from murdering the rich.
-Napoleon