<div>
What would be the point of that? Just curious, really ...<br />
<br />
You could use the Shell command to execute the executable. In my case, it's installed here:<br />
<br />
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Mana<wbr />gementStud<wbr />io<br />
<br />
So I'd use this:<br />
<br />
Shell &quot;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\Mana<wbr />gementStud<wbr />io\ssms.ex<wbr />e&quot;
</div>


<div>
Scott:<br />
<br />
Because this is just the first step that a user has to do before finalizing a report that I have programmed in Access. &nbsp;I just wanted to make it easier for the user when they launch my database, they can click a button to open SQL Server and have the query already there on the screen and ready to execute.<br />
<br />
Thanks,<br />
gdunn59
</div>


<div>
<div class="content wysiwyg-content">
I have an Access Database and I would like to add a button to my form that will automatically open SQL Server Management Studio (SSMS) via VBA.<br />
<br />
How can I accomplish this?<br />
<br />
Thanks,<br />
<br />
gdunn59
</div>
</div>


I have an Access Database and I would like to add a button to my form that will automatically open SQL Server Management Studio (SSMS) via VBA.

How can I accomplish this?

Thanks,

gdunn59

What would be the point of that? Just curious, really ...

You could use the Shell command to execute the executable. In my case, it&amp;#39;s installed here:

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio

So I&amp;#39;d use this:

Shell &amp;quot;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\ssms.exe&amp;quot;

Scott:

Because this is just the first step that a user has to do before finalizing a report that I have programmed in Access.  I just wanted to make it easier for the user when they launch my database, they can click a button to open SQL Server and have the query already there on the screen and ready to execute.

Thanks,
gdunn59

How to Open SQL Server Management Studio via VBA from MS Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.