Results 1 to 8 of 8

Thread: Acess db

  1. #1
    Xsecrets
    Guest

    Acess db

    Yeah just wondering how do I view my access database in linux? :P

  2. #2
    jman_77
    Guest

    Re: Acess db

    I believe you can install ODBC drivers to open and work with the database, but I don't think you'll get a nice GUI in linux. You may want to try PostgreSQL to replace Access in Linux. It makes more efficent databases anyhow

  3. #3
    nfallon
    Guest

    Re: Acess db


    I believe you can install ODBC drivers to open and work with the database, but I don't think you'll get a nice GUI in linux. You may want to try PostgreSQL to replace Access in Linux. It makes more efficent databases anyhow
    Is there a conversion utility out there to convert Access or SQL Server databases to PostgresSQL or mySQL database? If not is there a need for one?

    Neil

  4. #4

    Re: Acess db

    I believe you can convert SQL databases over to PosgresSQL or MySQL without to much of a hitch...but Access is another story, you might have to talk to big ole billy boy for that...but I think it would be an awesome application if we had it!

    Aragorn
    If you give a man a fire he'll be warm, if you light the man on fire he'll be warm for life.

  5. #5
    JimH
    Guest

    Re: Acess db


    Is there a conversion utility out there to convert Access or SQL Server databases to PostgresSQL or mySQL database? If not is there a need for one?

    Neil
    Scroll down the page for information on converting databases to PostgresSQL.
    http://techdocs.postgresql.org

    Don't know about MySQL. I imagine there is a way. Their website would probably be a good place to start.
    http://www.mysql.com/

    Jim H

  6. #6
    nfallon
    Guest

    Re: Acess db

    The sources recommended and the other information that I have found on the net are for using a named database on both sides. Last year I created and application that can convert Access and SQL Server 7.0 and up databases to Palm PDB format and vice versa. The database and tables could be selected by the user from list boxes. They did not need the database names and tables in advance.

    I think if something similar to this was available for converting the Access and SQL Server databases to PostgresSQL and mySQL there would be a lot more Windows defectors. Their data would be intact and they could experiment on the Linux platform with their data until they were comfortable with Linux.

    Neil



  7. #7
    JimH
    Guest

    Re: Acess db


    I think if something similar to this was available for converting the Access and SQL Server databases to PostgresSQL and mySQL there would be a lot more Windows defectors. Their data would be intact and they could experiment on the Linux platform with their data until they were comfortable with Linux.
    I'm going to agree with you completely after looking at some of these docs after posting the links. I had seen the references before on converting the db's, but I had never really read through them. After reading them, I would definitely say a better method is needed, and I imagine probably wanted.

    Jim H

  8. #8

    Re: Acess db


    The sources recommended and the other information that I have found on the net are for using a named database on both sides. Last year I created and application that can convert Access and SQL Server 7.0 and up databases to Palm PDB format and vice versa. The database and tables could be selected by the user from list boxes. They did not need the database names and tables in advance.

    I think if something similar to this was available for converting the Access and SQL Server databases to PostgresSQL and mySQL there would be a lot more Windows defectors. Their data would be intact and they could experiment on the Linux platform with their data until they were comfortable with Linux.

    Neil
    Wish my knowledge of databases was stronger than nill, I'd like to get in on a project like that.. :-[

    Aragorn
    If you give a man a fire he'll be warm, if you light the man on fire he'll be warm for life.

Bookmarks

Posting Permissions

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