MS Access调用SQL Server存储过程 [英] MS Access call SQL Server stored procedure

问题描述

我有一个MS Access应用程序，其中包含链接到SQL Server的所有表，因此在MS Access VBA代码或查询中，我使用这些表非常简单，我可以通过名称访问它们，例如[Customers].

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or query I work with those tables very simple, I access them via name, like [Customers].

此外，我在SQL Server中有一个名为sp_CopyData的存储过程，需要从VBA代码中调用该存储过程.

Also I have a stored procedure in SQL Server called sp_CopyData which I need to call from my VBA code. How can I do that without creating new connection to SQL Server (I already have it somewhere!? because I have access to tables)?

还是不可能?感谢任何帮助.谢谢！

Or it's impossible? Appreciate any help. Thanks!

推荐答案

找到正确的答案，应该是:

The right answer found out, it should be like:

Dim qdef As DAO.QueryDef
Set qdef = CurrentDb.CreateQueryDef("")
qdef.Connect = CurrentDb.TableDefs("[ANY LINKED TABLE TO MS SQL SERVER]").Connect
qdef.SQL = "EXEC sp_CopyData"
qdef.ReturnsRecords = False  ''avoid 3065 error
qdef.Execute

这篇关于MS Access调用SQL Server存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！