Results 1 to 12 of 12
  1. #1
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    142

    Thumbs up MS-ACCESS In Unix

    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
    Log On.
    Hack In.
    Go AnyWhere.
    Steal AnyThing.

  2. #2
    Join Date
    Apr 2002
    Location
    USA
    Posts
    5,779
    No

  3. #3
    Join Date
    Jan 2002
    Posts
    453
    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..

  4. #4
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    142
    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
    Log On.
    Hack In.
    Go AnyWhere.
    Steal AnyThing.

  5. #5
    Join Date
    Apr 2001
    Location
    St. Louis, MO
    Posts
    2,508
    Becouse all server windows is not good like unix.
    ?
    Mike @ Xiolink.com
    http://www.xiolink.com 1-877-4-XIOLINK
    Advanced Managed Microsoft Hosting
    "Your data... always within reach"

  6. #6
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    142
    ??
    Log On.
    Hack In.
    Go AnyWhere.
    Steal AnyThing.

  7. #7
    Join Date
    Jan 2002
    Posts
    453
    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

  8. #8
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    142
    Thank you Sir
    Log On.
    Hack In.
    Go AnyWhere.
    Steal AnyThing.

  9. #9
    Join Date
    Aug 2002
    Location
    Plymouth
    Posts
    212
    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.

  10. #10
    Join Date
    Aug 2001
    Posts
    107

  11. #11
    Join Date
    Aug 2002
    Location
    Plymouth
    Posts
    212
    Ben,
    I had gone to your thread. I think I am right what I said earlier.

  12. #12
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •