访问数据库共享策略 [英] Access database sharing strategies
问题描述
您使用什么策略让多人在访问数据库上工作？
What are the strategies you employ to let multiple people work on an access database?
可以在线托管它，并且其功能仍然可以正常运行，而无需开发自定义前端？
Is it possible to host it online and have its features still functional without having to develop a custom frontend?
MS Access作为一个软件有一些不错的功能，不需要任何编程配置：
MS Access as a software has a few nice features that don't require any programming to configure:
- 下拉列表 - 选择一个
- 多个复选框列表 - 选择多个
是否可以获得所有这些功能，即使在线上托管？我基本上想到了一种替代方法，可以使用GUI功能快速让人们使用数据，而无需使用webapp<> MySQL方式。
Is it possible to get all of these features available even when hosted online? I'm basically thinking of an alternate way to quickly get people to work with data using GUI features like the above without going the webapp<>MySQL way.
推荐答案
我听说过的一种方法是将访问数据库导入SQL Server数据库。
（几乎任何版本都可以。）
One way i've heard of, is to import the access database into a SQL Server database.
(Almost any version will do.).
然后使用Access链接到SQL Server数据库，并让用户像以前一样使用它。
Then link to the SQL Server database with Access and let users use it as they did before.
查看此链接： http://office.microsoft.com/en-us/access/HA010345991033.aspx < a>
Look at this link: http://office.microsoft.com/en-us/access/HA010345991033.aspx
如果你想在线解决方案，我建议使用正常的Web应用程序架构。 （与正确的数据库交谈。）
If you want an online solution i'd recommend going with a normal web application architecture. (Talking to a proper database.).
这篇关于访问数据库共享策略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
