替换MS Access表单 [英] Replacing MS Access forms

问题描述

我们在Access中制作了许多非常旧的数据输入表格，这些表格链接到我们的SQL Server数据库.每个表单可以具有任意数量的子表单.

We have a number of very old data entry forms that were made in Access that link to our SQL Server database. Each form may have any number of sub-forms.

我们希望不再使用这些访问前端，但是没有时间创建新的应用程序或Web应用程序来替换我们拥有的每种表单.

We'd like to move away from using these access frontends but don't have the time to create a new app or web app to replace every form that we've got.

是否有另一个选项可以链接到SQL Server，并允许可视化设计表单并自动链接到数据库?

Is there another option that would link to SQL Server and allow visual design of the form and automatic linkage to the database?

或者如果这是一个太多的问题，您能想到一种使手工编码表格变得更容易的方法吗?

Or if that's too much of an ask, can you think of a way to make hand-coding the forms easier?

推荐答案

根据经验，我认为您不会发现比Access更容易创建任何带有DB的表单的产品，工具或技术.

From experience, I don't think you will find any product, tool or technology any easier than Access for creating forms with a DB behind them.

您是否有访问开发者手册?过去，我发现这是宝贵的资源，可用于将Access作为SQL Server的前端在相当复杂的项目中实施最佳实践.

Do you have a copy of Access Developer's Handbook? In the past, I found this a valuable resource for implementing best practices in quite complex projects with Access as a front-end to SQL Server.

如果您要转到Web表单，我将看一下 IronSpeed Designer

If you want to move to web forms, I would take a look at IronSpeed Designer

这篇关于替换MS Access表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！