blocks|key|4520530|text|首先，数据库和Web应用程序不是相互排斥的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4520531|回到最初的问题，我已经做了很多这样的项目。一个客户开始时只有几个用户的小型Microsoft+Access数据库；当他们获得更多流量时，他们会迁移到web应用程序。|4520532|首先，您需要将数据从MS+Access数据库转换到SQL+Server。MS+Access数据库不能同时访问多个用户。然后开发了以SQL+server为后台数据库的Web应用程序。|4520533|就在您上线之前，您最后一次将数据从MS+Access数据库转换到SQL+Server。那么就不要再让他们使用旧的MS+Access数据库了。|4520534|4520535|将MS+Access数据库转换为Web应用程序的简便方法|blockquote|4520536|4520537|4520538|大多数情况下，创建MS+Access数据库的人都不是软件工程师，所以表没有规范化，也没有任何关系。我通常在SQL+Server中创建新的规范化数据库。然后编写一个小程序将这些数据从MS+Access转换到SQL数据库。|4520539|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|W|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Z|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|Q|$]]

First of all, Database and Web Application are not mutually exclusive. 

Back to original question, I have done multiple projects like that. A client started with small Microsoft Access database with a couple of user; then they migrate to to web application when they get more traffic.

At first, you want to convert data from MS Access Database to SQL Server. MS Access Database is not meant to access multiple users simultaneously. Then you develop the Web Application which uses SQL server as back end database. 

Right before you go live, you convert the data again from MS Access Database to SQL Server very last time. Then do not let them use old MS Access Database anymore.

<blockquote>
 Easy way to convert the MS Access database to Web application
</blockquote>

Most of the time whoever created MS Access database are not software engineer, so table are not normalized and do not have relationship at all. I normally create new normalized database in SQL Server. Then write a small program to convert those data from MS Access to SQL database.

blocks|key|1821326|text|您可以使用Office+365并拥有某种基于web的应用程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1821327|https://blogs.office.com/en-us/2012/07/30/get-started-with-access-2013-web-apps/|offset|length|1821328|或者，在SharePoint中存储访问，但您的功能将非常有限。请记住，任何VBA都不会在基于web的应用程序上运行。|1821329|另一种选择是使用SQL+Server+Express和ASP.NET，这两种软件都是微软免费提供的。不过，现在我要告诉您，如果您以前从未使用过这些技术，那么学习曲线将非常陡峭。然而，这个组合将给你最大的控制权！|1821330|您可以从这里获得.NET框架。|1821331|https://www.microsoft.com/en-us/download/details.aspx?id=30653|1821332|您可以从此处获取SQL+Server+Express。|1821333|https://www.microsoft.com/en-US/download/details.aspx?id=42299|1821334|entityMap|0|LINK|mutability|MUTABLE|url|1|2^0|0|0|28|0|0|0|0|0|0|1Q|1|0|0|0|1Q|2|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@$D|19|E|1A|1|1B]]|A|$]]|$1|N|3|O|5|6|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1D|8|@]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|R|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|C]]|Y|$5|U|V|W|A|$X|M]]|Z|$5|U|V|W|A|$X|Q]]]]

You can use Office 365 and have somewhat of a web-based application. 

<a href="https://blogs.office.com/en-us/2012/07/30/get-started-with-access-2013-web-apps/" rel="nofollow noreferrer">https://blogs.office.com/en-us/2012/07/30/get-started-with-access-2013-web-apps/</a>

Or, store Access in SharePoint, but your functionality will be quite limited. Keep in mind, no VBA will run on a web-based application.

The alternative is to use SQL Server Express, and ASP.NET, both of which are free from Microsoft. I'll tell you now, though, the learning curve will be quite steep if you have never used these technologies before. This combo, however, will give you the most control!

You can get the .NET framework from here.

<a href="https://www.microsoft.com/en-us/download/details.aspx?id=30653" rel="nofollow noreferrer">https://www.microsoft.com/en-us/download/details.aspx?id=30653</a>

You can get SQL Server Express from here.

<a href="https://www.microsoft.com/en-US/download/details.aspx?id=42299" rel="nofollow noreferrer">https://www.microsoft.com/en-US/download/details.aspx?id=42299</a>

blocks|key|1825081|text|本文详细介绍了转换microsoft+access+to+web+application的方法，通常有两种方法|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1825082|直接端口意味着简单的基本迁移，通过该迁移，您可以将基本访问表单或多或少逐字地移植到web门户中，即Microsft访问基于浏览器的版本，就像使用第三方工具一样。其中一些非常普通，因为它只允许您在internet浏览器中运行Access应用程序(呼！)或者可以非常拉长，然后限制你在之后可以改变的程度。在更复杂的情况下，需要顾问帮助您迁移系统。虽然知道你的用户数越高确实有帮助，但由于基于订阅的模型，第三方移植服务变得越不具吸引力。|style|BOLD|1825083|+upsize++-the更复杂或更复杂您的数据结构是使用自定义开发的升级，并且在以下情况下将系统拆分到web和数据层可能是值得的|1825084|1825085|你有一个特殊的过程或一些你想要保留的秘密。|ordered-list-item|1825086|可能会有大量的用户，并希望避免subscription|1825087|Inherently愤世嫉俗或谨慎，并希望针对特定的用户体验处理您自己的体系结构和security|1825088|Looking+|1825089|1825090|1825091|entityMap|0|LINK|mutability|MUTABLE|url|https://mindfieldconsulting.com/ways-to-convert-microsoft-access-to-web-application/^0|9|Z|0|0|0|4|0|0|8|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@$A|18|B|19|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|1A|8|@$A|1B|B|1C|F|G]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]|$1|K|3|L|5|M|7|1E|8|@]|9|@]|C|$]]|$1|N|3|O|5|M|7|1F|8|@]|9|@]|C|$]]|$1|P|3|Q|5|M|7|1G|8|@]|9|@]|C|$]]|$1|R|3|S|5|M|7|1H|8|@]|9|@]|C|$]]|$1|T|3|-4|5|M|7|1I|8|@]|9|@]|C|$]]|$1|U|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]]|W|$X|$5|Y|Z|10|C|$11|12]]]]

There are generally two approaches with more details covered in this article looking at ways to convert <a href="https://mindfieldconsulting.com/ways-to-convert-microsoft-access-to-web-application/" rel="nofollow noreferrer">microsoft access to web application</a>

Direct Port means simply a basic migration whereby you port more or less verbatim basic Access forms into a web portal i.e. Microsft Access to a browser-based version as is using a third-party tool. Some of these are quite mundane in that it just allows you to run the Access application inside an internet browser (whoopee!) or can be quite drawn out and then limits you on how much you can change afterward. With even more complex cases requiring a consultant to help you migrate the system. Though it does help to know your user count as the higher you tend to be, the less appealing a third-party porting service becomes due to subscription-based models.

Upsize -the more involved or complex your data structure is an upsize using custom development and splitting the system across web and data tiers might be worth it if 

<ol>
<li>You've got a special process or some secret sauce you're looking to keep.</li>
<li>Likely going to have a significant user count and want to avoid subscription</li>
<li>Inherently cynical or cautious, and want to handle your own architecture and security</li>
<li>Looking for a specific user experience</li>
</ol>

blocks|key|5936539|text|四年后，根据这一点：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5936540|https://www.comparitech.com/net-admin/microsoft-access/|offset|length|5936541|对许多人来说，这仍然是一个问题。Access几乎可以在任何时间内转换为Web+App。特别是Access表单非常容易使用像Jam.py这样的库创建。|5936542|这一过程在2021年4月在Reddit上进行了讨论：|5936543|https://www.reddit.com/r/MSAccess/comments/mj4aya/moving_ms_access_to_web/|5936544|我看到相当多的Access数据库有超过100个表，都成功地转换为SQLite3。通过提供的链接检查导入的表格后，将自动创建表单。这使得访问报告和业务逻辑保持不变。可以在用于Jam.py的LibreOffice中将报告设计为模板。如果需要，可以将业务逻辑从VB迁移到Python。SQLite被选为转换的默认DB，因为它非常可移植。看起来转换后的应用程序可以通过导出/导入移动到Jam.py支持的任何数据库。干杯|5936545|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|1J|0|0|0|0|0|22|1|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@$D|13|E|14|1|15]]|A|$]]|$1|L|3|M|5|6|7|16|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|C]]|U|$5|Q|R|S|A|$T|K]]]]

Four years after and according to this:
<a href="https://www.comparitech.com/net-admin/microsoft-access/" rel="nofollow noreferrer">https://www.comparitech.com/net-admin/microsoft-access/</a>
still a question for many. Access can be converted to an Web App in almost no time. Particularly Access Forms are super easy to crate with the library like Jam.py.
The process was discussed on Reddit in April 2021:
<a href="https://www.reddit.com/r/MSAccess/comments/mj4aya/moving_ms_access_to_web/" rel="nofollow noreferrer">https://www.reddit.com/r/MSAccess/comments/mj4aya/moving_ms_access_to_web/</a>
I see quite a few Access databases with more than 100 tables, all converted successfully to SQLite3. After inspecting the imported tables via provided link, Forms are automatically created. Which leaves the Access Reports and Business Logic untouched. Reports can be designed in LibreOffice for Jam.py as Templates. Business Logic can be moved from VB to Python, if there is a need to do so.
The SQLite was selected as the default DB for the conversion, since it is very portable. Looks like the converted App can be moved to any DB that Jam.py supports, by Export/Import.
Cheers

As per requirement, we need to convert the existing MS Access database to a web application. Is there any easy way to convert the MS Access database to web application? As of now they are inserting the data to access db using access Forms. User also wish to continue access form feature even if we create new web application for the same. That means user should have the option to access the MS access database through Access forms as well as web application.

Please guide me away to solve this issue.

Best Regards,
Ranish

Easy way to convert the MS Access database to Web application

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

根据要求，我们需要将现有的MS Access数据库转换为web应用程序。有没有什么简单的方法可以将MS Access数据库转换为web应用程序？到目前为止，他们正在使用access表单向access数据库插入数据。用户也希望继续访问表单功能，即使我们为它创建了新的web应用程序。这意味着用户应该有权通过access表单...

问将MS Access数据库转换为Web应用程序的简便方法
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将MS Access数据库转换为Web应用程序的简便方法EN