Ask the Expert

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.

This was first published in September 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: