<div>
You should be able to use ado in your add-in and just open the mdb as a connection rather then an application then use execute and a dataset to pull what ever information you would like.
</div>


You should be able to use ado in your add-in and just open the mdb as a connection rather then an application then use execute and a dataset to pull what ever information you would like.

<div>
Hi<br />
I want to create an application where the user can build an Access query as they would in Access and then use the resulting SQL to pull data through to Excel. This is why it is important that the user sees the Access query designer
</div>


Hi
I want to create an application where the user can build an Access query as they would in Access and then use the resulting SQL to pull data through to Excel. This is why it is important that the user sees the Access query designer

<div>
<div class="content wysiwyg-content">
Hi<br />
In my VB.net Excel Add-in I want to see if there is a way to create a new Access Query so that the user just sees<br />
the Access query and not the rest of Access. Is this possible?<br />
Thanks
</div>
</div>


Hi
In my VB.net Excel Add-in I want to see if there is a way to create a new Access Query so that the user just sees
the Access query and not the rest of Access. Is this possible?
Thanks

VB.net Excel Add-in Call up Access Query

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.