Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    38

    Arrow Unanswered: MS Access and MySQL - a few q's

    Right now Im converting my MS Access database to use MySQL as the engine. Im exporting my tables to the MySQL db and then relink them. This creates a few problems:

    1) When I relink a table I have to delete the old one, and link a new table with the same name from the MySQL db. This means that after Im finished I would have to redesign my whole relationship connections. Is there a way/app to switch an existing table with a linked one without deleting it 1st?

    2) MS (fucking) Access wont export default values, "required" properties (=not null in SQL), and comletely trash all format and input mask properties. Im using EMS MySQL GUI Manager to fix the required and default properties and then I have to rewrite the whole formatting properties. Is there a better way/app for doing this?

    3) Ms Access exports auto numbered columns as regular int columns (why?). Im changing the properties wo auto-inc with the GUI manager but I forsee problems with adding new lines. Is there a way around this?

    Thanx ahead, dd+

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    although it might not answer all your questions, a quick look at freebie dbDesigner 4 might be useful.

    izy
    currently using SS 2008R2

Posting Permissions

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