Results 1 to 6 of 6
  1. #1
    sdel_nevo is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    Gloucester, UK
    Posts
    402

    Linked tables on Mysql Database

    Hi Guys

    I'm sorry if i have posted this in the wrong location.

    my company very shortly will be using moving the back end tables of our access database onto Mysql.


    is their a way in code to create the database connection so that i do not have to install any mysql drivers on each client's PC?

    if this is possible, how would this be best done? as a VBA script on a form that opens? or is another way possible.

    this is now way out of my comfort zone, and i have never done anything like this before so i think im heading for one hell of a learning curve

    any help would be fantastic

    Many thanks

    Steve

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    sdel_nevo is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Location
    Gloucester, UK
    Posts
    402
    Hi RuralGuy

    Thats great, many thanks for the links mate
    Steve

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're very welcome and I hope they are helpful to you. Good luck on the project.

  5. #5
    nhorton79 is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Apr 2015
    Posts
    34
    You can also use:
    http://www.bullzip.com/products/a2m/info.php

    I used this recently to convert my access tables to MySQL. It can connect to your MySQL database and upload or it create a SQL dump file.


    Sent from my iPhone using Tapatalk

  6. #6
    nhorton79 is offline Advanced Beginner
    Windows 8 Access 2007
    Join Date
    Apr 2015
    Posts
    34
    Also. Using the MySQL workbench makes things easier for making changes to the database layout than using the command line.


    Sent from my iPhone using Tapatalk

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-14-2014, 01:30 PM
  2. linked mysql database
    By nkuebelbeck in forum Misc
    Replies: 3
    Last Post: 05-30-2013, 09:58 AM
  3. Replies: 1
    Last Post: 08-24-2012, 07:11 AM
  4. Replies: 5
    Last Post: 05-16-2012, 12:48 AM
  5. MySQL Linked Tables - Carriage Return
    By warrenk in forum Access
    Replies: 1
    Last Post: 03-28-2010, 01:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums