[Gllug] Reading an Access97 mdb file

Andy Farnsworth farnsaw at stonedoor.com
Tue Jan 7 13:50:37 UTC 2003


You should be able to connect to the Access DB via ODBC.  If you have
another ODBC compliant DB, you can move the DB there and make Access the
front end for the users who are currently using it.  I have successfully
done this for several clients and moved the actual DB itself to a much more
robust system like MySQL, PostgreSQL, and MS SQL Server.  Once you do this,
you will have remote access to the DB from almost any platform and/or
language you can think of.

Andy Farnsworth

-----Original Message-----
From: gllug-admin at linux.co.uk [mailto:gllug-admin at linux.co.uk]On Behalf
Of BABA Yoshihiko
Sent: January 07 2003 12:54
To: gllug at linux.co.uk
Subject: Re: [Gllug] Reading an Access97 mdb file


Stan wrote:

> The card system is running on WinXP Pro.  This sounds like a more
> powerful method, there are a few other things that I'd eventually like
> to be able to do with this damn access database and this might be the
> way to go, and would save me fiddling with VB (which is what I thought
> I'd have to do).
>
> I'll pop into a bookshop at lunchtime and see how tricky it all looks
> (I've never tried controlling windows aps through scripting - I wasn't

If on Windows, you can use ADO with your favourite scripting language.
I sometimes use ADO from Ruby.  One good feature of ADO is it can
open/save recordset as XML format.

--
BABA Yoshihiko


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug




More information about the GLLUG mailing list