[TriLUG] Access databases under linux

[Andrew Perrin]

Well, I followed the link and found the dbf2mysql program referenced
enticingly. Followed it up, though, and found that it reads and writes dbf
files, which are not Access files, so I'm not sure exactly what the
article was referring to. Perhaps since Access has a dbf input filter one
can use that to go back and forth, but it wouldn't solve the original
poster's problem of consistently using an Access db on a linux machine
without using windows.

There are also some MSSQL->MySQL tools, but these seem pretty universally
to run on the Windows side, and dump either via ODBC or directly.

ap

----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin at unc.edu - http://www.unc.edu/~aperrin
 Assistant Professor of Sociology, U of North Carolina, Chapel Hill
      269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA


On Fri, 15 Feb 2002, Jon Carnes wrote:

> Considering there are Opensource tools for import/export from linux databases 
> (MySQL) to Access databases:
>   http://www.linux-mag.com/2001-02/pr_mysql_01.html
> 
> It should be possible to access an Access Database directly from a linux box 
> (even if it is stored on a Linux server).
> 
> Jon Carnes
> ===
> On Friday 15 February 2002 01:00 pm, Andrew Perrin wrote:
> > Depends on what the definition of "using windows" is -- with ODBC you
> > still need Access (or, more correctly, Microsoft Jet) running to serve the
> > database, unless things have changed since I was doing Access work (3-4
> > years ago).  So you can read/write from a linux client, but a windows
> > server has to host the database itself. AFAIK there's no way around that
> > -- that is, no linux-capable program that can read/write Access files.
> >
> > ap
> >
> > ----------------------------------------------------------------------
> > Andrew J Perrin - andrew_perrin at unc.edu - http://www.unc.edu/~aperrin
> >  Assistant Professor of Sociology, U of North Carolina, Chapel Hill
> >       269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA
> >
> > On 15 Feb 2002, Chris Hedemark wrote:
> > > On Fri, 2002-02-15 at 12:30, Vestal, Roy L. wrote:
> > > > Is there a way to access a Microsoft Access database under linux
> > > > without Wine/Win4Lin/VMware?
> > > >
> > > > I have an Access97 db that I need to leave in that format for sharing
> > > > but I'd like to access it without using Windows.
> > >
> > > Hmmm how about ODBC?
> > >
> > > http://www.easysoft.com/products/2002/main.phtml
> > >
> > > --
> > > ***********************************************************
> > >
> > > | Chris Hedemark
> > > | Hillsborough, NC
> > > | http://yonderway.com/chris
> > > | GPG Public Key - http://yonderway.com/chris/hedemark.gpg
> > >
> > > ***********************************************************
> > >
> > > _______________________________________________
> > > TriLUG mailing list
> > > http://www.trilug.org/mailman/listinfo/trilug
> >
> > _______________________________________________
> > TriLUG mailing list
> > http://www.trilug.org/mailman/listinfo/trilug
>