Results 1 to 2 of 2
  1. #1
    buienxg is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    15

    Convert Exisitng Access Database to Access Frontend MySQL backend


    Hi all

    I am stuck in a quagmire. I need to move the database off to a external server which has Mysql on it. The database is built up with a lot of forms and queries on it.

    I have not seen an easy way to export my tables to mysql. The more worriesome issue is that will everything break if I were to try and link and run my existing queires forms and reports ?

  2. #2
    pdebaets is offline Competent Performer
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Los Angeles
    Posts
    235
    What do you mean by "external server"? Access will not work well on a WAN or over the internet. It isn't designed for that.

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

Similar Threads

  1. Access 2007 Database Backend Security
    By bakkouz in forum Access
    Replies: 2
    Last Post: 10-10-2011, 11:12 AM
  2. Replies: 1
    Last Post: 08-30-2011, 11:54 PM
  3. Export MySQL database into Access
    By Yesideez in forum Import/Export Data
    Replies: 6
    Last Post: 08-08-2011, 12:13 PM
  4. access split DB to mySQL (backend only)
    By rnbwkat in forum Access
    Replies: 1
    Last Post: 05-31-2010, 07:19 PM
  5. Access database to Mysql
    By fsmikwen in forum Access
    Replies: 4
    Last Post: 11-16-2009, 05:40 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