Earlier, I asked:
[...] What is the easiest way to allow people to make changes to that database without needing to resort to the methods above?
There, one answer suggested to "consider a switch from using Access to using MS SQL. Access (2007 at least) has Wizards to help you convert pretty easily.".
Therefore I am thinking about migrating our existing Access databases (.mdb) files to a server with MySQL, so that users can access the database over Access/ODBC again.
What tools I currently have:
I have the following software:
- Windows 7 with Microsoft Access 2007 clients
- A Debian server with
mysql, Version 14.12
While searching for possible solutions I've found a lot of guides, but most of them for Access versions 2000 or below (like this one). They also suggest some shareware, or other free-to-trial tools that I don't even want to install. These include:
However, I am not that experienced with Windows or Microsoft's products at all to know what still works and where I should take extra special care.
What I need:
Ideally, I would like a easy solution to migrate the Access database to SQL data, which I could then access again using ODBC. I am more interested in the Access ⇒ MySQL part and how to use the SQL data in Access again. I know how to administer MySQL databases, that's not the issue.
- If there's a wizard, is it easy to use? How does it work?
- If there's a software tool, which one does the job best (for free)?
- If I can do it manually, where should I take care?
On a side note: Is that even possible with MySQL or do I need Microsoft's SQL Server? (This is suggested in: How to: Run the SQL Server Import and Export Wizard)