Access is an excellent front-end development tool for Client/server, with easy to learn, easy to use, user friendly, easy to develop, and flexible for other database interfaces. However, it is relatively slow to handle large amounts of data. Shenzhen power Supply Bureau Existing 600,000 users, the following 6 offices, through the 64K DDN and draw connected, if there is a sales office to 10,000 users to deal with, it will take 2-3 hours, seriously affect the development of other businesses. Therefore, when there is a large amount of data to be processed, it cannot be processed on the client side, but must be handled on the server side.
However, the majority of access and server connections are connected through ODBC, which makes it more difficult to invoke a background stored procedure. The author through the actual work in the long-term groping, according to different business needs, you can use the following three methods to call the background stored procedures.
First, Access submits the job to the background, which corresponds to a stored procedure. In SQL Server 6.5, a task Manager is established to create the corresponding task; In Oracle 8.0, the job is created by managing job Queue. In Access, you insert a job in the Job_list table that typically runs every night. The business of these jobs typically involves processing very large amounts of data, while the real-time is low, and the typical example in our business is a large amount of electricity bills per night.
Second, create some triggers (Trigger) on the server side and activate them in access. In SQL Server 6.5 and Oracle 8.0, this is done through the Create Trigger. In access, different triggers are activated by inserting, modifying, and deleting records, depending on the business. One example in our business is that when a business person modifies a user's meter reading, the trigger that calculates the electricity bill is activated, and the user's electricity bill is immediately recalculated. This way, you can share the same program with the batch calculation of electricity, without re-development on the access side, there can be faster response speed of the front end.
Three, more than two methods, can only be said to indirectly call the background stored procedures, Access also provides a direct call method, you can use access to pass a query directly to the database server to send commands.
To create an access pass-through query, follow these steps:
(1) In the Database window, click the Query tab, and then click the New button.
(2) In the New Query dialog box, click Design View Options, and then click the OK button.
(3) Click the Close button in the Show Table dialog box.
(4) On the Query menu, refer to SQL statement criteria, and then click the Pass command.
(5) On the toolbar, click the Properties button to display the query property sheet.
(6) In the Query property sheet, set the ODBC connection string property to specify the database information to connect to. You can enter connection information: "ODBC;DSN=NTSERVER0; Uid=sa; pwd=;D Atabase=bms ", or build with the" generator "button.
http://www.bkjia.com/PHPjc/631162.html www.bkjia.com true http://www.bkjia.com/PHPjc/631162.html techarticle access is an excellent front-end development tool for Client/server, with easy to learn, easy to use, user friendly, easy to develop, and flexible for other database interfaces. However, it is going to be processed on a large amount of data when ...
