Access Stored Procedures

  • Thread starter Thread starter Jcasual
  • Start date Start date
J

Jcasual

I am build an application with visual basic as the front
end and access 97 as the database.

Does access have Stored Procedures?
Is there a way to make access behave like it does?
 
No, Access doesn't have Stored Procedures, and, AFAIK, there's no way to
simulate them if you're interacting with the database from outside of
Access.
 
Saved Queries are very similar to stored procedures (albeit not in T-SQL)
and you can access and use Queries from VB (and, I am sure, from C++, also).

Larry Linson
Microsoft Access MVP
 
1. Make sure your VB project has a reference to DAO then:

Private Sub RunMyQuery()
Dim DBName As String

DBName = "Full_Path_To_The_Database"
Set dbs = DBEngine.Workspaces(0).OpenDatabase(DBName)

dbs.Execute "QueryNameHere"
End Sub
 
I'm kinda' lazy so it's definitly more efficient to me to build and test the
query (especially a parameter one) under Access.
 
What about on my Client?

Do you think accessing functions on my A97 database will
improve the performance of the overall application? I am
trying to determine with the above method is better then
making recordset in the vb Client.

I'm thinking by calling a function from the vb client
would act as a simulation of a stored procedures.
 
I never tested. It should be faster. Think about running an update query
over a few thousand records...
 
Back
Top