[TriLUG] Access databases under linux

[Chris Hedemark]

If you share them from one of the Windows boxes instead of the Linux
box, ODBC works then.

Or if you convert the MDB to MySQL and use MyODBC on Windows the Windows
boxes can easily read/write the MySQL RDBMS.  Be aware that MS Access
databases don't do well in a shared environment.  They are meant to be a
single user database.  Back in my BOPS days they had two products they
were using with an MS Access back end, and it never failed, if two
people got into the database at the same time the MDB would sometimes
double or triple in size and become utterly corrupted.  Usually MS
Access could clean it but from time to time I've had to restore from
tape.

So if you can at all help it, avoid sharing MDB between multiple users. 
If you're just using MS Office as the front end, it will work happily
against MySQL or PostgreSQL.

On Mon, 2002-02-18 at 09:52, 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
-- 
***********************************************************
| Chris Hedemark
| Hillsborough, NC
| http://yonderway.com/chris
| GPG Public Key - http://yonderway.com/chris/hedemark.gpg
***********************************************************
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 232 bytes
Desc: This is a digitally signed message part
URL: <http://www.trilug.org/pipermail/trilug/attachments/20020218/4b71e779/attachment.pgp>