 | View Full Version : MS-ACCESS In Unix Captain 08-24-2002, 07:59 AM Hello Evry body I would like know If I can work MS-ACCESS in server unix . That mean I there any software can do that or no. Thank you Techark 08-24-2002, 08:01 AM No anantatman 08-24-2002, 08:23 AM there is unixODBC, but i'm not one hundred percent sure if it can be used to connect to an .mdb file... but it does allow connections to MSSQL server, etc.. Captain 08-24-2002, 08:33 AM Mr.anantatman Can you give me that software. Becouse all server windows is not good like unix. And Do you know any way to change database MS-ACCESS to SQL Thank you RackMy.com 08-24-2002, 09:33 AM Becouse all server windows is not good like unix. ? Captain 08-24-2002, 09:43 AM ?? anantatman 08-24-2002, 09:59 AM your best bet would be to export access as a .sql file.. you can then run the sql script in mysql .. once thats done, then you can use any mysql client api to access it. (php, perl:dbi, python, etc..) as far as unixODBC, do a search on google.com, or freshmeat.net its open sourced so its free Captain 08-24-2002, 10:02 AM Thank you Sir combs 08-24-2002, 12:01 PM MSAccess is not supported in UNIX. However if anantatman gives you software for connectivity of MSSql server from unix, you can import your access database in MSSql using Enterprise manager of MSSql server...but i doubt unix support mssql server. ben 08-26-2002, 12:39 AM http://www.webhostingtalk.com/showthread.php?s=&threadid=57208 ;) combs 08-26-2002, 07:24 AM Ben, I had gone to your thread. I think I am right what I said earlier. wmac 08-26-2002, 07:42 AM The way I prefer is this: Install a MyODBC Driver, (MySQL driver for Windows), then create a ODBC connection pointing to your MySQL server. Now export your Access Daabase directly from Ms_Access to MySQL. In this way you will be able to export both data and structures. Mac |