473,772 Members | 3,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2345
"Ashish" <pa*******@gmai l.com> wrote in message
news:11******** **************@ v46g2000cwv.goo glegroups.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************ **********@v46g 2000cwv.googleg roups.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
2312
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, delete, use, etc.. stored procedures soley from asp (i.e., no GUI or console- like being hosted on Brinkster)? The tutorial on aspfaq.com mentions that stored procedures can be
1
14359
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 is there any way to create stored procedures or triggers in Access. Also, I want to know that can we migrate data from any platform? i downloaded this rdbms s/w from http://www.vaman.net/vmndataserver.asp i tried this s/w. this solved my most of...
3
1401
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
3486
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 Procedures. I thought stored pricedures were an Oracle/MS SQL Server thing and don't know how they work with Access Jet. I've looked at some of the help on stored procedures in A2003, but really don't understand what's going on. Can someone...
2
6122
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 is shut down by Windows. When I make changes to my procedure, it doesn't seem to always change what is being executed. Furthermore, sometimes the procedure just disappears from my database. I am starting to think that the stored procedure...
9
8989
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 or writing procedure from backend SQLServer. Back End First we'll cover how to write a stored procedure in back end. The following example is how to create a store procedure for MSSql Server:
5
1809
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 and triggers for my database using T-SQL,but i noticed bad performance (its kinda slow),so i ask:writing them in C# would i achieve a (considerable) performance gain? Thanks in advance :)
7
1333
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? 4)What is the need of stored Procedures? Your Reply will be highlt appreciated.
1
1904
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 step..
0
9620
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10104
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9912
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8934
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7460
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6715
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4007
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2850
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.