[TriLUG] Access databases under linux

Andrew Perrin andrew_perrin at unc.edu
Mon Feb 18 10:53:45 EST 2002


I agree with the OP re: moving it to MySQL or PG if you can, then using
ODBC to make Access the frontend to these.

If, however, you can't do that for institutional reasons (which is often
true), you can share the datasource from a windows box using ODBC, then
read it from the linux box. You can also use Perl's DBD::Proxy to do much
the same thing in a somewhat "lighter" (on system resources) way than
using ODBC.

Access *claims* to be multi-user safe, meaning that the record locking
should keep multiple reads/writes safe from one another. However, I, too,
have experience with this safety being, er, less than perfect.

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 Mon, 18 Feb 2002, Vestal, Roy L. wrote:

> I need to leave the Access DB as is. I need 2 Windoze based boxes to access
> the DB and 1 Linux box. On the Linux box, I have Win4Lin and VMware, so I
> can get to it via them, but I don't want to use them if possible. I like
> having resources available. :)
> 
> -----Original Message-----
> From: Tanner Lovelace [mailto:lovelace at wayfarer.org]
> Sent: Saturday, February 16, 2002 12:29 AM
> To: trilug at trilug.org
> Subject: Re: [TriLUG] Access databases under linux
> 
> 
> 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.
> 
> Not sure about accessing, but if you want to convert, you might
> take a look at this page:
> 
> http://www.osfaq.com/article.php3?sid=76
> 
> Tanner
> -- 
> Tanner Lovelace | lovelace at wayfarer.org | http://wtl.wayfarer.org/
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
> GPG Fingerprint = A66C 8660 924F 5F8C 71DA  BDD0 CE09 4F8E DE76 39D4
> GPG Key can be found at http://wtl.wayfarer.org/lovelace.gpg.asc
> --*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--*--
>  Those who are willing to sacrifice essential liberties for a little 
>  order, will lose both and deserve neither.  --  Benjamin Franklin 
> 
>  History teaches that grave threats to liberty often come in times
>  of urgency, when constitutional rights seem too extravagant to 
>  endure.  --  Justice Thurgood Marshall, 1989 
> _______________________________________________
> TriLUG mailing list
> http://www.trilug.org/mailman/listinfo/trilug
> 




More information about the TriLUG mailing list