使用MS Access作为MySQL数据库的前端 [英] Using MS Access as a front-end to MySQL db
问题描述
我正在将MySQL DB用于我的android应用程序.我已经在Ubuntu LAMP服务器上安装了phpmyadmin,并使用它来访问数据库.是否可以使用MS Access 2010访问数据库,因为我需要定期对数据库进行修改
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
推荐答案
如果目标是更改数据而不是结构,则使用MS Access是一个很好的解决方案,因为您可以使用litlle非常有效地编辑链接表中的任何内容设置工作.
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.
要实现此目的,首先需要下载并安装 MySQL ODBC驱动程序.
To achieve this, first you need to download and install the MySQL ODBC driver.
为了避免出现问题,即使您使用的是64位系统,我也建议您安装32位驱动程序. 32位将无法正常工作,而64位并非总是如此.
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.
安装后,打开 ODBC控制面板并添加一个指向您的MySQL数据库的条目
Once installed, open the ODBC control panel and add an entry pointing to your MySQL database
然后在Access中可以使用此ODBC条目添加链接表
Then in Access you can add linked tables using this ODBC entry
表被链接后,它们的行为就好像它们是MS访问表一样,您可以打开它们并编辑数据等等.
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.
这篇关于使用MS Access作为MySQL数据库的前端的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!