SQL Server后端缺少MS Access数据库复选框列表筛选器 [英] MS Access Database Check Box List Filters Missing On SQL Server back end

问题描述

当我将Access 2007连接到SQL Server(无论是通过ADO记录集还是通过链接表)时，我不再在数据表列过滤器中获得复选框列表(具有可用的过滤器值).

When I connect Access 2007 to SQL Server (whether by ADO recordset or by linked table) I no longer get check box lists (of available filter values) in the datasheet column filters.

此功能仅适用于MDB/ACCDB和/或DAO吗?

Is this feature available only with MDB/ACCDB and/or DAO?

推荐答案

我认为本机Access表的数据表视图中的复选框由表设计中的显示控件"属性控制.我不记得表在SQL Server中时可用的内容.如果在数据表视图"中提供表单，则应该能够将复选框控件绑定到SQL Server列.

I think the check box in datasheet view of native Access tables is governed by the "Display Control" property in the table design. I don't recall what's available when the table is in SQL Server. If you provide a form in "datasheet view", you should be able to bind a check box control to the SQL Server column.

编辑:我想我昨天误解了你的问题.如果单击Office按钮，请选择当前数据库"，然后在过滤器查找选项"下的"ODBC字段"框中进行检查...这样做是否满足您的要求?

Edit: I think I misunderstood your question yesterday. If you click the Office Button, select Current Database, then put a check in the "ODBC fields" box under "Filter lookup options" ... does that do what you want?

这篇关于SQL Server后端缺少MS Access数据库复选框列表筛选器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！