[ale] Microsoft Access Database - PHP on Linux

[Benjamin Scherrey]

Yes - I recently completed moving an absurdly large Access database to a PostgreSQL backend. 
Replaced all the tables with ODBC links and it went pretty smoothly. There are, naturally, some 
gotchas - and Access seems to insist on ignoring indexes at times, preferring to scan entire tables at 
the oddest time - but it works much better than the pure Access system and explicit pass-thru SQL 
code can get around Access' stupidity in most cases. I wrote some python code to help with the 
move as you'll, undoubtably, be exporting the data several times before getting it where you'd like.

	good luck,

		Ben Scherrey

1/17/2003 5:16:47 PM, Jonathan Glass <jonathan.glass at ibb.gatech.edu> wrote:

>Anyone have any experience getting access (no pun) to Microsoft Access
>databases from Linux/Apache/PHP?  I looked at unixODBC, but it requires
>another product from easysoft, and basically a dedicated machine to
>"server" the ODBC connection.  I'm trying REALLY hard to avoid
>installing a M$ Server, so any thoughts are appreciated.
>
>Anyone ever moved the backend of a complicated Access DB to something
>like Postgre or MySQL?  Since the DB is simple tables, and all the work
>is in the reports and forms, I THINK I should be able to move the actual
>data into Postgres or MySQL, and setup the ODBC links on the win2k
>clients to point to the appropriate server/database combo.
>Unfortunately, that entails installing and configuring ODBC drivers on
>25 machines...
>
>Any thoughts/comments/gotchas are greatly appreciated.
>
>Thanks
>-- 
>Jonathan Glass
>Systems Support Specialist II
>Institute for Bioengineering & Bioscience
>Georgia Institute of Technology
>404.385.0127
>
>_______________________________________________
>Ale mailing list
>Ale at ale.org
>http://www.ale.org/mailman/listinfo/ale
>



_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale