<div>
Oh I see, is there a work around for this? Or is there a way to convert the database from MS Access to a SQL database?
</div>


Oh I see, is there a work around for this? Or is there a way to convert the database from MS Access to a SQL database?

<div>
Can you please give me an example on how to make use of data adapters for retrieving records from a MS Access db? I tried to make a query but I haven't figured out how to make use of the parameters to work with the query. Thanks in advance.
</div>


Can you please give me an example on how to make use of data adapters for retrieving records from a MS Access db? I tried to make a query but I haven't figured out how to make use of the parameters to work with the query. Thanks in advance.

<div>
<div class="content wysiwyg-content">
Hi I'm making a Windows Form application making use of C#.NET VS 2005 and MS Access 2003. I don't understand why the stored procedure options are disabled. Can you help me out? I need to create customized sp. Thanks in advance.<br />
<a href="https://filedb.experts-exchange.com/incoming/2009/12_w01/217257/stored-disabled.JPG" target="_blank" class="file-inline" title="stored disabled (38 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>stored-disabled.JPG</a>
</div>
</div>


stored-disabled.JPG

Hi I'm making a Windows Form application making use of C#.NET VS 2005 and MS Access 2003. I don't understand why the stored procedure options are disabled. Can you help me out? I need to create customized sp. Thanks in advance.

Why &quot;Add Query&quot; disables option for using stored procedures?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

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 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.

Why &quot;Add Query&quot; disables option for using stored procedures?

Why "Add Query" disables option for using stored procedures?