将 ms-access 前端转换为基于 Web 的技术
谁能推荐最好的基于网络的技术/语言来重写 ms-access 前端？我已经将表转换为 MySql 并将所有查询移至存储过程中。该语言需要能够处理多个结果集。
另外，我需要 GUI 尽可能与当前的 ms-access 前端相似。因此，新语言需要具有完整的 CRUD、选项卡式表单、数据表样式子表单、组合框和报告等功能。
我已经涉足了 html、css、php、javascript 和 java，但是这些有能力或合适吗？我听说 Ajax 或 jQuery 可能是最佳选择。
Can anyone recommend the best web-based technology/language for rewriting a ms-access front-end? I've already converted the tables to MySql and moved all the queries into stored-procedures. The language will need to be able to handle multiple result sets.
Also, I need the GUI to be as similar as possible to the current ms-access front-end. So the new language will need to have features including full CRUD, tabbed forms, datasheet style sub-forms, combo-boxes and reports.
I've dabbled a bit with html, css, php, javascript and java but are any of these capable or suitable? I've heard that Ajax or jQuery might be the way to go.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这是一个被误导的目标。
Web UI 使用完全不同的范例，因为 Web 前端是无状态的，具有未绑定的数据，而 Access 应用程序是有状态的且受绑定的。除非您在 AJAX 开发上投入大量资金，否则 1:1 翻译将是在 Web 浏览器中实现 UI 的灾难性方式。
也就是说，您应该研究 Access 2010 和 Sharepoint Access Services，它们允许您使用可以在 Web 浏览器中运行的 Web 表单和 Web 报告创建 Access 前端，而无需更改。这可能比您自己的基于 AJAX 的替代品便宜一个数量级。
This is a misguided goal.
Web UI uses completely different paradigms because a web front end is stateless, with unbound data, whereas Access apps are stateful and bound. A 1:1 translation will be a disastrous way to implement a UI in the web browser, unless you invest a HUGE amount in AJAX development.
That said, you should look into Access 2010 and Sharepoint Access Services, which allow you to createn Access front end with web forms and web reports that can be run in the web browser unchanged. This would likely be an order of magnitude cheaper than rolling your own AJAX-based replacement.
我们正在这样做。为了保留 Access 中的“电子表格样式表单”，其中包括排序和过滤功能作为所有屏幕上的标准功能，我们决定在其之上使用 silverlight + Infragistic 工具包。到目前为止，我们已经使用这些工具开发了一些屏幕，并且对结果非常满意。
We are in the process of doing this. In order to keep the "spreadsheet-style forms" that we have with Access, and which include ordering and filtering capabilities as standard on all screens, we took the decision to go for silverlight + Infragistic toolkit on top of it. Up to now, we have already developped a few screens with these tools, and are quite satisfied with the result.