Hi everybody,
I am using the access database in my project. My front end is Visual basic. I am using stored procedure in access. I want to know that how to call back Access stored procedure. Please suggest. Thanks in advance.
Hi everybody,
I am using the access database in my project. My front end is Visual basic. I am using stored procedure in access. I want to know that how to call back Access stored procedure. Please suggest. Thanks in advance.
Access to submit to the background job, All these operations corresponds to one month of the stored procedure. In SQL Server 6.5, through Task Manager to establish the corresponding Task; while in Oracle 8.0, through Managing Job Queue to create the corresponding Job. In Access, in job_list table, insert a job, these jobs usually run once every night. These operations correspond to the business generally need to handle very large amounts of data, while the real-time is relatively low, in our business the more typical example is a large number of tariff calculation every night. Check and reply.
In the Server-side set up some triggers, the activation of these triggers in Access. In SQL Server 6.5 and Oracle 8.0, the Create Trigger through to achieve. In Access, according to different business, through the insert, update, delete records to activate the different triggers. In our business, an example of this is that when business people change a user's meter readings, the activation of the trigger calculation of electricity can be immediately re-calculate the user's electricity. In this way, both can share the same bulk billing procedures, not in the Access-side re-development, there could speed up the response speed of the front end. So pleaes check this procedure and reply.
Access also provides a direct method call, you can use Access pass-through query to send commands directly to the database server.Access pass-through query to establish the following steps:
(1) In the Database window, click "Search" tab, and then click "New" button.
(2) In the "New Query" dialog box, click the "Design View" option, and then click "OK" button.
(3) In the "Show Table" dialog box click "Close" button.
(4) In the "Search" menu, point to "SQL statement condition", and then click "pass" command.
(5) on the toolbar, click "Properties" button to display the query property sheet.
(6) in the query property sheet, set "ODBC connection string" attribute to specify the database connection information. Can enter the connection information: "ODBC; DSN = ntserver123; UID = sa; PWD =; DATABASE = abc", or "Builder" button generates.
(7) the stored procedure returns no records, it will "return to record" attribute set to "no."
(8) In the "SQL Pass-Through Query" window, enter the pass-through query: exec statistics. Statistics is a SQL Server database, a stored procedure.
(9) Close the query, save the query as: stat_query.
You can also run pass-through query of the following methods:
(1) with Microsoft Access macros OpenQuery.
(2) with the following event procedure:
Code:Private Sub Statistics _Click () Dim dbas As Database, cdr As QueryDef Dim tmq123 As Dynaset Dim str123SQL As String Set dbsa = CurrentDb Set qdf123 = dbsa.OpenQueryDef ( "stat_query") qdf123.Execute Set dbas = Nothing End Sub
The above method is implemented in SQL Server 6.5 has nothing to problems in Oracle 8.0 can not be realized in the error message is: ORA-00900 invalid SQL statement. Because of this method does not require an intermediate table to line up or activate the background stored procedure, so its application surface is very wide, those who need to handle large volumes of data services, can go into Server-side processing, such as statistical reports. Best of luck.
Bookmarks