Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting

Post new topic   Reply to topic
MS Acess Stored Procedure
View previous topic :: View next topic  
Author Message
ladoleste
Newbie


Joined: 21 Mar 2005
Posts: 7

PostPosted: Oct 20th, 2005 09:26 AM    Post subject: MS Acess Stored Procedure Reply with quote

hi
I wander if it is possible to execute and pass parameter to a stored procedure in MS-Access.

10x a lot
Back to top
View user's profile Send private message Send e-mail MSN Messenger
DoobieKeebler
Moderator


Joined: 17 Jun 2005
Posts: 254
Location: 181°15'2.003"W, 93°5'16.956"N

PostPosted: Oct 25th, 2005 08:58 AM    Post subject: Reply with quote

It's possible to execute a stored procedure. If the query you want to "run" is named qryLatePayers, then the recordset source would be qryLatePayers (instead of, say, SELECT * FROM Customers). Or am I m isunderstanding what you mean by a "stored procedure"? As far as passing parameters, I believe I read that it's possible. A Google search should turn up at least a few hits.
_________________
Always take into account what a user would never ever in a million years do, because someone will.

"In theory, there's no difference between theory and practice. In practice, there is." -- Yogi Berra
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic