以Access为前端，以sql server为后端 [英] Access as the front end and sql server as the backend

问题描述

我有一些带有许多字段的Access表.我已经将每个访问表迁移到6或7个SQL Server表.我正在使用sql server2008.现在我想使用Access作为前端，这样我就可以在Access中输入数据，但是它将存储在sql server中.我知道我必须建立一个ODBC连接.但是我不确定如何创建访问表单以将其用作前端.很抱歉，这是一个基本问题...

I have some Access tables with many number of fields. I have migrated each access table to 6 or 7 sql server tables. I am using sql server 2008. Now I want to use Access as the front end so that I can enter the data in access but it will be stored in sql server. I know that I have to make a ODBC connection. But I am not sure of how to create a access form to use it as a front-end. I am sorry if it's a basic question...

推荐答案

您可能会想从一个空的Access数据库开始(因为表结构以及任何现有的表单和报表将与您在SQL Server中创建的内容不匹配).

You will probably want to start with an empty Access database (since the table structures and any existing forms and reports will not match what you created in SQL server).

第一步是建立与SQL Server数据库的ODBC连接.然后，您将链接" SQL Server中的表到您的Access数据库.

First step is to establish an ODBC connection to your SQL Server database. Then you will "link" the tables in SQL Server to your Access database.

现在，您有了一个Access数据库，其中包含从SQL Server链接的所有表.这些表仍在SQL Server中活动"，并且在Access中对其进行编辑时，数据将存储在SQL Server中.

Now, you have an Access database with all the tables that you linked from SQL Server. Those tables still "live" in SQL Server and when you edit them in Access the data will be stored in SQL Server.

然后，您可以使用这些表构建Access表单和报表，就像这些表是Access的本机一样.

You can then build Access forms and reports using these tables just as if the tables were native to Access.

这篇关于以Access为前端，以sql server为后端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！