我怎样才能找到“源代码”访问查询？ [英] How can I get to the "source-codes" of the access-queries?

问题描述

Hello Guys，



我想分析现有的访问应用程序以进行重新设计。因此，我要读出我能得到的所有代码（包括查询）。在整个过程中，我可以使用自己的算法来分析代码。



如何访问Access-Queries的源代码？



谢谢。 :)



我尝试过：



<$ p $我已经在访问应用程序对象上找到了他们的名字：

< pre> Access.Application.CurrentData.AllQueries

但我只能通过

 AccessObject 

的抽象接口检索信息。



直到现在我才在MSDN中找不到任何内容，而我在谷歌的搜索标准中找不到所需内容。你能给我一个提示吗？

解决方案

你自己无法获得查询：它们是从访问引擎获取信息的代码的一部分，并且是有效的只是该代码中的文本字符串（希望使用参数化查询而不是字符串连接）。引擎本身不会存储我被问过这个SELECT，然后是INSERT的历史记录。

Hello Guys,

I want to analyze an existing access application for reengineering-purpose. Therefore I've to read out all code (including the Queries) I can get. Throughout I would be able to analyzie the Code with my own Algo.

How Can I get to the "Source-Codes" of the Access-Queries?

Thanks. :)

What I have tried:

I already got thier names over the Access Application Object over:

<pre>Access.Application.CurrentData.AllQueries

But I only can retrieve the Information over the abstracted Interface of the

AccessObject

.

I found nothing in MSDN until now and my Search Criterias in Google don't find things... needed. Can you give me a Hint?

解决方案

You can't get the queries themselves: they are part of the code that gets info from the access engine, and are effectively just text strings in that code (hopefully with parameterised queries rather than string concatenation). The engine itself does not store a history of "I was asked this SELECT, and then that INSERT".

这篇关于我怎样才能找到“源代码”访问查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！