| Author |
Topic |
|
rajeshkumar77
Starting Member
46 Posts |
 Posted - 2001-12-25 : 02:14:09
|
| Dear Friends,Is MS Access Supports Stored Procedures ?If anyone knows about this please share ur ideasThanks in AdvanceYoursRajesh |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-25 : 02:41:45
|
| you mean to say can you create Stored procedure in Ms Access??. nopes, therez nothing like Explicit Stored procedure the way its in Sql Server but there are Modules in Access, wherein you can certainly create procedures ,functions . in a way you can write code like stored procedures .or if you are trying to say whether it you can use Stored Procedures of Sql Server when you link the server with Ms Access , you can certainly do that. in Ms Access 2000 when you create a new database by selecting Project (Existing Database) and link you it to you Sql Server database, it pulls out all your tables, views and STORED PROCEDURES too.HTH-------------------------Graz's Baby is my Master:)Edited by - Nazim on 12/25/2001 02:42:25Edited by - Nazim on 12/25/2001 02:48:07 |
 |
|
|
rajeshkumar77
Starting Member
46 Posts |
Posted - 2001-12-25 : 03:14:04
|
Dear Nazim ,Glad to meet u once again.In SqlServer we can create and use stored procedures to get faster performance by executing those sp's ...either from java application or from asp applicationIn the sameway i am trying to get the faster performance from ms access database.Is there any way to get this..by using modules..sp's or else etc.,if u any idea about this please share ur opinion.Thankyou VeryMuchYoursRajeshquote:
you mean to say can you create Stored procedure in Ms Access??. nopes, therez nothing like Explicit Stored procedure the way its in Sql Server but there are Modules in Access, wherein you can certainly create procedures ,functions . in a way you can write code like stored procedures .or if you are trying to say whether it you can use Stored Procedures of Sql Server when you link the server with Ms Access , you can certainly do that. in Ms Access 2000 when you create a new database by selecting Project (Existing Database) and link you it to you Sql Server database, it pulls out all your tables, views and STORED PROCEDURES too.HTH-------------------------Graz's Baby is my Master:)Edited by - Nazim on 12/25/2001 02:42:25Edited by - Nazim on 12/25/2001 02:48:07
|
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-25 : 06:19:16
|
| Access is designed for single use (or very small numbers) and ease of use - not speed. That's why there's SQL Server. I don't think you can use modules in Access to speed it up. Best bet is to use SQL Server. If that's not an option, you can work with a hybrid (linked tables in Access, stored procedures in SQL). Or you can use pure Access, save money, but run slowly. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-25 : 08:05:05
|
| Am not sure whether Sql Server will be faster or Ms Access , you really cant make out the performace gains in a small database. but as smcreadile suggest's. Access is for small databases where as Sql server is for larger enterprise application's.IMHO if its a small database , you really cant figure out the speed difference. but there are loads of options in sql server to enhance its speed, simplify its maitenence. but Access is simpler. about using modules and other stuff for increasing performance. as smcreadile suggest you cant do much abt it.-------------------------Graz's Baby is my Master:) |
|
|
|
saglamtimur
Yak Posting Veteran
91 Posts |
Posted - 2001-12-27 : 03:27:39
|
| In Ms Access i use Stored Queries like SP, for my ASP pages. Take a look at this link ( http://www.stardeveloper.com/articles/010701-1.shtml ) which is a good example how to create Stored Queries in Access and execute from an ASP page. I think it will give you an idea. |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2001-12-27 : 07:09:51
|
| Here's an example of executing an SP from within Access....obviously dimension the appropriate bits first. This is the important bit... Set qdfTeamsNeeded = cn.CreateQueryDef("q1") qdfTeamsNeeded.sql = "{ call usp_TeamsNeeded_BrokerCode (?,?) }" qdfTeamsNeeded.Parameters(0).Value = Forms!frm_brokerTeamSelection!cbx_brokers qdfTeamsNeeded.Parameters(1).Value = Me.UID Set rstTeamsNeeded = qdfTeamsNeeded.OpenRecordset(dbOpenSnapshot)The stored procedure used above has 2 i/p variables hence the (?,?) partmay help someone anyway ? |
|
|
|
abd_hadi
Starting Member
2 Posts |
Posted - 2010-10-12 : 03:17:04
|
| how can i create stored procedure from another stored procedur?abdu |
|
|
|
abd_hadi
Starting Member
2 Posts |
Posted - 2010-10-12 : 03:20:00
|
| how i can create stored procedure from another stored procedure in ms access project?thank youabdu |
|
|
|
|
Stored Procedures in MS Access