从Java Access中调用VBA函数 [英] calling VBA function in Access from Java

问题描述

我有一个使用MS Access设计的数据库，并在数据库中编写了VBA功能 当我尝试使用JdbcOdbc Bridge从Java程序调用此函数时，出现SQLException，消息为未找到函数" 数据库中的函数访问修饰符为"public"，我尝试在连接URL中使用"ExtendedAnsiSQL = 1"，但失败 是否缺少某些东西，或者无法从外部程序调用这些功能?

I have a database designed using MS Access with a VBA function written in the database When I try to call this function from a java program using JdbcOdbc Bridge I get SQLException with the message meaning "function is not found" the function access modifier in the DB is "public" and I tried to use "ExtendedAnsiSQL=1" in the connection URL but I failed Is there something missing or these functions cannot be called from external programs ?

推荐答案

MS Access分为两个部分，即您要连接的Jet/ACE数据库和前端"，这是一个更好的词. ，其中包含表格，报告和代码.我不相信您可以在没有应用程序实例的情况下在MS Access中引用代码.

MS Access comes in two parts, the Jet/ACE database, which you are connecting to, and the "front-end", for want of a better word, that holds the forms, reports and code. I do not believe you will be able to reference code in MS Access without an instance of the application.

这篇关于从Java Access中调用VBA函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！