问题描述
我正在尝试这样做，以便我可以拥有一个组合框，根据我在文本框中输入的服务器名称和数据库名称列出SQL数据库中可用的表。我不想创建一个passthrough querydef。我在网上读到，我可以将DAO Recordset设置为组合框的行源。问题是我不知道如何为DAO Recordset提供连接字符串。
我使用passthrough querydef让它工作。我只是试图消除需要passthrough querydef。
I''m trying to make it so that I can have a combo box that lists the tables available in a SQL database based on the server name and database name that I have entered into textboxes. I don''t want to create a passthrough querydef. I read online that I might be able to set a DAO Recordset as the row source of the combobox. The problem is that I don''t know how to provide a connection string to a DAO Recordset.
I have gotten this to work using a passthrough querydef. I''m just trying to do away with needing the passthrough querydef.
推荐答案
这篇关于组合框直接连接到ODBC源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！