The code above is VB.Net.

You can see some examples on error handling in VBA here: http://www.cpearson.com/excel/ErrorHandling.htm

r.stebbens 78867

I think you are right, it is probably an access settings. I just tried the same code on the SQL server and it worked just fine.

r.stebbens 78867 (11/30/2010)

---

type, status etc are key words in SQL you might want to try putting square brackets round those columns. eg.

...

This is just a stored procedure. So I am just trying to change a stored procedure that I already have.

bump

The store procedure works, but when I try to change or even just save without making any change I get the following error: ADO error: Incorrect syntax near the keyword...

There are a couple ways to do this. here is one. I created a function that takes 2 parameters. one is the name of the datalist where the...