Problem solve Get help with specific problems with your technologies, process and projects.

Is there a way to create a SQL procedure in Access?

First of all I would like to congratulate you of such great site your team has made. I have been studying VB.NET for two months now and I have run into a problem. Because I couldn?t make my (Northwind.mdb) file work under SQL server, I jumped exclusively to Access 2002 and I am using OleDB commands to write my project. In the book there are all on SQL server. Everything was just fine after I reached to the project that uses the SQL to create a procedure command to insert a new row to the database, but unfortunately I couldn?t use the same SQL procedure command in Access.

Am I doing something wrong, or there is a way to create SQL procedure in Access? How I can use my northwind.mdb in SQL server, which is installed from disk 4 of Visual Studio .NET?
You should install the .NET Framework Quickstarts and Samples, which comes with MSDE, a stripped-down SQL Server version, and it automatically loads the northwind and pubs sample databases. This allow you to use all the SQL Server features, will be far more performant, and is what almost every book I know about uses.

Dig Deeper on .NET Architecture Best Practices

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.