473,406 Members | 2,390 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

How to create stored procedures in Ms access

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
4 2331
"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
I don't think you can create storage procedure in access.

Apr 27 '06 #3
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
> 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Dragonhunter | last post by:
Hello, The aspfaq.com seems to really push stored procedures, and I hear the same advice here all the time. So I want to take the advice. Is it possible to create and practically maintain,...
1
by: Manish Bafna | last post by:
speaking of me, I'm not very new to Access, but I haven't worked on it as a professional. I know that you can fire queries in Access, but I don't think you can create views. i want to know that...
3
by: Ed Pinnegar | last post by:
I've looked everywhere for info on stored procedures using Access. Any info on how to make one? Thanks! Ed
5
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored...
2
by: bshumsky06 | last post by:
Hi, I am trying to create stored procedures in MySQL. Does anyone have a suggestion on a good IDE to use. I have been working with the MySQL Query Browser but it generates errors very often and...
9
by: jyothi1105 | last post by:
Hi all, Here is some information which could help people who want to create stored procedures and execute them in their program. You can create stored procedures in two ways: Through front end...
5
by: FP | last post by:
Hi, i have read that with Visual Studio 2005 it's possible to create stored procedures and triggers for a Sql Server 2005 database. I must admit that i have already written the stored procedures...
7
by: sonia.sardana | last post by:
Hi frnds, can somebody has the full material of stored procedures, cz i have no knowledge regarding it. 1) How to Create Stored procedures? 2) Why they are used? 3) When they are created?...
1
by: mmikram | last post by:
Hi, I am new to DB2, My installation of DB does not include Development center... but i need to create stored procedures. Geeks please help me how to create stored procedure and please step by...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.