Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    139

    Unanswered: In Access 2003 ALL database tables are innodb (mysql equivalent), or exist and tables

    Access is called "PC based Database Applications" while MySQL is "Database Server", this is a foundamental difference between the two and, other kind of db generally ? Well may connect with JAVA DESKTOP APPS the MySQL db ? If, yes How much get bigger then the App(eg 1MB) if data 200KB?

    In Access 2003 ALL database tables are innodb (mysql equivalent), or exist and tables in Access non support "Referential Integrity in PK-FK"? What is the default When creating tables in Access 2003(type of TABLE), and how this may be changed?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Mind to elaborate ?
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    they are separate issues
    Access is a front end development (A GUI) it can talk to many different types of data backend

    depending ion the version of MySQL you are using you may or may not be able to define and rely on foreign keys/ relational definitions

    when you are creating a MySQL database to connect to a MS Access front end you would be better off either creating the database in something like MySQL Administrator or via code using DML as a query within Access
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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