There are a number of ways you can achieve this, if you goto the mysql sofware contribution page, there are some VBA functions which produce SQL files from an access database. You can then import these into your MySQL database. (I thouhgt I'll save you the hassle and provide a link: http://www.mysql.com/portal/software/item-98.html) There are commercial tools which allow this too (here is one: http://www.realsoftstudio.com/sqlporteraccess.php) In our workplace a popular app was written in access some years ago and due to growth it kept falling over and as a quick fix, I created linked tables so the application thinks its talking to its same old Access table but these are pointing to MySQL behind the scenes. I hope this helps.
The secret to creativity is knowing how to hide your sources.
Joined: Apr 03, 2002
Thanks for the good input and the nice link that you gave that enables my Access db to be converted on MySQl db. It's really cool tool and indeed very easy to do! But actually, this is just half of the solution of my problem, we need basically to convert our Access db to MySQl db to be run on Linux. Since i don't have experience yet on linux environment, the first consideration was to let myself known of the MySQL Windows. Now that i've already converted my Access db to MySQl db (windows), the next problem would be how to have this MySQL db (windows)on MySQL linux? I assumed that there would be not so much problem on deploying this since they are the same MySQL but just on different platform, but i am not sure of course. My next approach would be installing MySQL on linux and i'll see and try how to solve it. If you have any hints, further suggestions to this that would make things a little easier, i would be grateful to have them. Thanks, Rema
Joined: Jun 29, 2003
Hi Rema, Sorry if this reply is far too late to be meaningful. From my experience of doing a port from windows to Linux the only thing you have to be careful about is the naming of the tables due to case sensitivity on linux and not on windows. For example a table called Faisal_Test on windows can be called from a query as select * from faisal_test however, under Linux, tables Faisal_Test and faisal_test are two different tables. The reason behind this (as you may already know) is that MySQL stores all the databases and the tables in files on the filesystem under <MySQL_HOME>/data/<database_name>/<all the files of your tables> I hope this helps. - FK [ July 25, 2003: Message edited by: Faisal Khan ]