Fair enough - I had forgotton about the useful "link-table" feature in Access.
The problem is the ODBC driver for MSAccess AIUI is just a front-end on the Jet DB Engine. I don't think there is anything compatible with this available under Linux (and a quick "Google" didn't produce anything useful). If MySQL wasn't in the equation, you could in principle use Oracle's dblinks and Synonyms to do something similar to MSAccess's link tables. That's no where near being in the "as good as" category I realise, but it maybe gives you another avenue to explore? Of course if you do SQL that joins Oracle tables to MySQL tables then this is a non-starter. David. "Dennis M. Gray" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > David, > > There are many issues that must be considered before one can make a > generalised statement that the data should be transferred. I am not > especially fond of MS Access as a DBMS but it has a reasonable UI and > can link to other databases via ODBC. In my situation, I develop test > data on an Oracle databases and have many link tables in MS Access. > Oracle is the production database for the government agency I work for > and I am not about to change that. I have local Access tables that I use > for conversion and other data manipulations and it works fine. > > I used the DBI::ODBC on Windows to create large amounts of test data by > reading my MS Access tables. > > I also use the DBI::Oracle to extract other sets of test data and > reformat for input into a legacy system. > > I use MS Access with ODBC to link my mySQL tables from another > application. > > I use PHP and mySQL for a website I have developed but a lot of the > testing is still done using MS Access and ODBC. > > I have not used any UNIX ODBC drivers yet. > > Regards, > > Dennis > > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of David Claughton > Sent: Wednesday, 24 March 2004 8:42 PM > To: [EMAIL PROTECTED] > Subject: Re: ODBC + MSAccess + Perl + Linux or FreeBSD question. > > > I would be inclined to dump MSAccess and transfer the data to an > Open-Source database (e.g. MySQL www.mysql.com ) instead. > > MySQL has a Windows version as well, so you should be able access the DB > in both environments, if that is a requirement. > > Regards, > > David. > > "Ricardo Pichler" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi everyone, > > I'm try to make this work: perl + unixodbc + > > MSAccess but I can't" > > > > Anybody make this work? Or others ways to read and > > write access file with perl in linux or freebsd? > > > > Thank's in advance! > > -- > > Ricardo Pichler > > > > > >
