如何在android智能手机中打开ms access数据库? [英] how to open ms access database in android smartphone?
问题描述
很久以前,我已经在vb 6中创建了应用程序软件,该软件可以从我的PC中的Ms access访问数据库.现在,我正在寻找将Ms access数据库放到我的android手机中并查看它.该怎么做?
I have created application software in vb 6 long year back which accessing database from Ms access in my pc. Now I am looking for put that Ms access database in my android phone and view it. How to do that?
推荐答案
首先,这里需要理解一些定义,即数据库,软件和操作系统.Access具有两方面的优势,它将前端GUI管理系统与后端数据库引擎Jet/ACE结合在一起.
First, there are some definitions to understand here, namely database, software, and operating system. Access is two-fold as it combines a Front-End GUI management system with a Back-End database engine, Jet/ACE.
Access作为软件程序严格来说是Windows PC软件.Jet/ACE数据库服务器严格是Windows PC技术.因此,Access的任何组件都不能在任何其他操作系统(包括Mac,Linux,iOS和Android)中运行.如此说来,Google Play或Chrome网上商店中可能列出了不是Microsoft产品的私有开发人员解决方案.
Ms Access as the software program is strictly a Windows PC software. Jet/ACE database server is strictly a Windows PC technology. So, neither component of Access can run in any other operating system including Mac, Linux, iOS, and Android. Now with that said, there may be private developer solutions listed on Google Play or Chrome web store which are not Microsoft products.
因此,为了在Android上运行Access数据库内容,必须进行某种类型的转换和开发.注释中提到的一种这样的路由包括 SQLlite (就像Access作为文件服务器数据库或以单个文件)声称是部署最广泛的数据库.
Therefore, some type of conversion and development is warranted in order to run your Access database content on Android. One such route mentioned in the comments includes SQLlite (which is like Access as a file server database or database that exists as individual files) claimed to be the most widely deployed database.
为此,您需要执行以下操作:
In order to do this, you need to do the following:
- 为您的计算机下载免费的SQLlite,并为Android设备下载应用程序.
- 然后,您必须将数据库表导出为流行的数据平面文件格式(csv,txt,xml).
- 接下来,您需要使用某种类型的管理控制台将此类数据导入SQLlite(Firefox浏览器具有出色的插件 SQLlite 模块),然后从上述数据类型导入/添加数据.实际上,使用代码,您可以通过ODBC直接连接到Jet/ACE引擎以提取数据库内容,然后将其迁移到SQLlite,而无需使用csv,txt,xml导入/导出路由.
- 将您的移动设备连接到计算机.
- 只需在文件夹之间移动文件即可传输sqllite文件.
- Download the free SQLlite for your computer AND as an app for your Android device.
- Then you must export your database tables into popular data flatfile formats (csv, txt, xml).
- Next, you need to import such data into SQLlite either with some type of management console (Firefox browser has a great plugin Add-on) or with code (Python maintains a built-in SQLlite module) and import/append data from aforementioned data types. In fact with code you can directly connect to Jet/ACE engine via ODBC to extract database content and then migrate it to SQLlite without need of csv, txt, xml import/export route.
- Connect your mobile device to your computer.
- Transfer the sqllite file by simply moving files over between folders.
Other considerations is to run your Access as a web database in Office365 and log in via your Android over the web. Alternatively, export your Access database to server level database system (SQL Server, MySQL, PostgreSQL, etc.) that runs over the web and then download the corresponding system app to view and manage content or build your own app to connect. Same above route with data file export or coding will convert between Access and any other system.
这篇关于如何在android智能手机中打开ms access数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!