access做mysql前端_使用MS Access作为MySQL数据库的前端

最新推荐文章于 2023-05-04 22:56:53 发布

研途风物

最新推荐文章于 2023-05-04 22:56:53 发布

阅读量474

点赞数

文章标签： access做mysql前端

本文链接：https://blog.csdn.net/weixin_31421625/article/details/113146187

版权

I am using MySQL DB for my android application. I have installed phpmyadmin on my Ubuntu LAMP server and using it to access my DB. Is there any possibilities to access the DB using MS access 2010, as I need to do perform modifications on a regular basis to my DB

解决方案

If the aim is to change the data and not the structure, using MS access is a good solution, as you can edit anything in linked tables very efficiently with litlle setup efforts.

To achieve this, first you need to download and install the MySQL ODBC driver.

In order to avoid issues, I advise you to install the 32 bit driver, even if you're on a 64 bit system. The 32bit will work flawesly, which is not always the case of the 64 bit.

Once installed, open the ODBC control panel and add an entry pointing to your MySQL database

Then in Access you can add linked tables using this ODBC entry

Once the table are linked, they will behave as if they are MS access tables and you can open them and edit data, and much more.