Stored Procedures Help 1

[eatwork]

Hi, I'm a little new to this and was wondering if anyone has the syntax of how to create a stored procedure within ms access 2000? Thank you

 

[ZmrAbdulla]

Is it not a query? Or..?
What are you trying to do?

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[eatwork]

Hi ZmrAbdulla
Thank you for your response. I wasn't too sure if a query was the same as a stored procedure because all of the articles I read were connecting through sqlserver and using stored procedures. The reason I asked this was that stored procedures allow for certain things to be coded within the procedure and creates an increased level of security that I would like to incorporate into my ms access system. Do I need to use sql server to be able to accomplish this? thank you

 

[RoyVidar]

There is a concept of Stored Procedures within Access, but as far as I know, they don't allow much more than the stored queries of Access (they will become more or less Access stored queries - so well - OK it's the concept, isn't it ;-) ).

Here's one article Working with MS Access Stored Procedures in VB.NET. Part 1 with some details. Though this is VB.Net coding, the same SQL can be used through utilizing for instance the ADO command object.

So I think the answer to your question is, yes, you would need SQL server to be able to accomplish this. If cost is an issue, there are free versions, whith some limitations, for instance the MSDE, and I believe there's a SQL server 2005 version that is free too.

Roy-Vidar

 

[ZmrAbdulla]

SQL Server? I can't say anything.. I have never experienced that..

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[eatwork]

Thank you for your help royvidar and zmrabdulla. I guess I will need to move to SQL server to accomplish this task. Thanks