Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: MySQL and Access (or ODBC)

    Hi!

    Is it possible that I use MySQL as the Database backend for Access? Maybe over ODBC.
    I need it because Access will be the administrative tool for the Database and ther will also be a webpage which is meant for public access to view so of these data.

    If Access is unable to "access" a MySQL Database, are there similar tool which could do it?

    thx

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    Access accesses mySQL just fine via ODBC. you can find the driver on the mySQL site.

    you might want to consider using innodb tables with mySQL (innodb tables "understand" referential integrity whilst mySQL native tables leave all that to you, the programmer).

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    mysql

    Spend the money and use SQL Server. You won't regret it! mysql may be fast but it's nothing compared to SQL Server (won't do have the stuff.)

Posting Permissions

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