D
dave h
Hi,
I'm somewhat familiar with using stored procedures with VB.Net and SQL
Server but I'm relatively new to using Access 2003 and the Jet DB. It seems
from some reading that using ADO with the Jet DB should allow for some basic
stored procedure coding, but I'm having a hard time finding examples and
getting going with this. So, my questions are:
1. Is it true that the Jet DB supports stored procedures using ADO?
2. Can someone provide an example of creating and using such a SP or point
me to some documentation of this?
3. What are the basic limitations of Jet SPs versus SQL Server SPs?
Thanks for any light you can shed on this issue - Dave H.
I'm somewhat familiar with using stored procedures with VB.Net and SQL
Server but I'm relatively new to using Access 2003 and the Jet DB. It seems
from some reading that using ADO with the Jet DB should allow for some basic
stored procedure coding, but I'm having a hard time finding examples and
getting going with this. So, my questions are:
1. Is it true that the Jet DB supports stored procedures using ADO?
2. Can someone provide an example of creating and using such a SP or point
me to some documentation of this?
3. What are the basic limitations of Jet SPs versus SQL Server SPs?
Thanks for any light you can shed on this issue - Dave H.