UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How to convert Access BE DB to MySQL?    
 
   
portman98
post Oct 18 2006, 04:06 AM
Post#1



Posts: 311
Joined: 13-May 06



Dear All,
I have an assignment to change the back-end database of the MS Access 2003 application to MySQL.
Oknow nothing about MySQL and can someone share with me we should I start. Is there any friednly user interface to create a MySQL database/table instead of the Admin command. And also how to link and tranfer the existing data over.
Please help.
Thanks.
Go to the top of the page
 
dannyseager
post Oct 18 2006, 04:28 AM
Post#2


UtterAccess VIP
Posts: 13,031
Joined: 2-March 04
From: Leicester, UK


Search for MySQL control Center.
It's no longer in production but you should be able to find a copy from somewhere... if not then PM me and I'll try and e-mail it you.
Once you#ve created your DB then simply create an ODBC Connection to it and then export from your existing BE to it via the ODBC Connection... then link the MySQL tables (via ODBC) in your existing FE.
One thing you might also need to do is go into every table and add a timestamp field.
Go to the top of the page
 
kuifjexx
post Oct 18 2006, 04:36 AM
Post#3


UtterAccess VIP
Posts: 7,232
Joined: 2-January 03
From: Belgium


This links will help you
=> MySQL Control Center
=> Migrating from Microsoft Access to MySQL
Greetz from Belgium compute.gif
uc aka Kuifjexx
Go to the top of the page
 
portman98
post Oct 20 2006, 02:34 AM
Post#4



Posts: 311
Joined: 13-May 06



Thanks for the links, they are very useful indeed.
Go to the top of the page
 
kuifjexx
post Oct 26 2006, 06:39 AM
Post#5


UtterAccess VIP
Posts: 7,232
Joined: 2-January 03
From: Belgium


Glad I could help you sad.gif
reetz from Belgium compute.gif
Luc aka Kuifjexx
Go to the top of the page
 
Paul_Churchill
post Mar 8 2010, 05:40 AM
Post#6


UtterAccess VIP
Posts: 1,404
Joined: 27-February 07
From: Barton-under-Needwood, Staffordshire, England


Oh my goodness - the secret is out - Danny is the Stig !!!
Go to the top of the page
 
BananaRepublic
post Mar 8 2010, 07:10 AM
Post#7


Dungeon Cleaner
Posts: 1,504
Joined: 16-June 07
From: Banana Republic


FWIW, you could try out MySQL's Workbench as well. This provides a GUI for administering & designing MySQL databases.
It's just me but I personally prefer to build the tables then import the data into the new structure. This way I know that there won't be problems due to differing data types and whatnots.
You may find it interesting as well the links contained within helpful:
Beginner's Guide to ODBC
HTH.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 03:07 AM