By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,336 Members | 2,315 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,336 IT Pros & Developers. It's quick & easy.

How to create stored procedures in Ms access

P: n/a
Hi
i'm Ashish
Can anyone tell me how to create procedures in Ms Access
Please do mail me at pa*******@gmail.com

Apr 27 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Ashish" <pa*******@gmail.com> wrote in message
news:11**********************@v46g2000cwv.googlegr oups.com...
Hi
i'm Ashish
Can anyone tell me how to create procedures in Ms Access
Please do mail me at pa*******@gmail.com


That's not how this group works, sorry. Ask a specific question and someone
will be glad to help I'm sure. By procedures, do you mean VBA code or SQL
queries or ...

Posting your e-mail address will likely cause you to receive lots of junk
mail too.

Regards,
Keith.
www.keithwilby.com
Apr 27 '06 #2

P: n/a
I don't think you can create storage procedure in access.

Apr 27 '06 #3

P: n/a
Ashish wrote in message
<11**********************@v46g2000cwv.googlegroups .com> :
Hi
i'm Ashish
Can anyone tell me how to create procedures in Ms Access
Please do mail me at pa*******@gmail.com


If you really mean Jet stored procedures, have a look at these

http://support.microsoft.com/kb/q202116/
http://support.microsoft.com/?kbid=201493

This is for VB.Net, but I think you can can execute these SQL
statements
on an ADO connection.

http://www.devcity.net/PrintArticle.aspx?ArticleID=18

I don't think this allows for any "Alter Proc" statements, I think
you'll need to drop the SP, then recreate it, if necessary.

--
Roy-Vidar
Apr 28 '06 #4

P: n/a
> I don't think you can create storage procedure in access.

What you CAN do is to create an ADP, connect it to a SQL <=2000 database
and then create stored procedure from within Access.
If you change the projecttype or the database you CANNOT create stored procedures
from within Access.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
Apr 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.