Alon Weinstein wrote:
How about meeting them half-way -- first thing to suggest using mysql/postgresql as the database instead of access -- they're free, and at least I know mysql can run on Windows without a problem. Access has no advantages over mysql in this kind of setup, and mysql by far surpasses Access as a DB engine. (if Access could even be called that).
Yes, that's one thing I noticed in my googling now - MySQL should be easy to put underneath Access calls due to ODBC support. I'm pretty surte PostgresQL (my personal favourite)
can do this too.
Unfortunetly, at the moment Postgres only has a cygwin version for Windows. There is no native Win32 version at this stage. Also, due to name folding differences, you may find that some tweaking of the SQL statements is required. I have started a project in the past to allow easy translation between SQL variants, but lost my funding (http://www.sf.net/projects/dbsconv).
Shachar
-- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
