SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jul 2002
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL and Access

    Hello,
    I'm using ODBC to link the tables in mySQL to Access. What is the right procedure in creating this database?

    Should I create all the tables in mySQL and then link it via ODBC to Access and then starting building the database or can I create the database with Access and export it to mySQL? I tried doing the latter but things like "primary key" info did not transfer to mySQL. For example, in the Access, i set "ID" to be my primary key. I exported this table to MySQL and then I commanded to "describe" the table - it did not have "PRI" next to the "ID"...

    Thanks in advance for your help.

    Daeung

  2. #2
    SitePoint Zealot JEmLAC's Avatar
    Join Date
    Apr 2002
    Location
    Kansas City
    Posts
    156
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    At first bounce, I'd say the first method is your best bet. Access, up to version 2000 was never very good at "upsizing" and even then, it was only any good at going to SQL Server. No surprise there.

    Access does function remarkably well as a front end for server databases. It has a decent reporting engine and if you don't mind getting your hands dirty with VB, a pretty good small/medium scale programming environment.

    HIH

    B
    Morning person by habit, not by nature.

  3. #3
    SitePoint Member
    Join Date
    Jul 2002
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks

    Thanks for the advice!

    Daeung


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
  •