外文翻译--DESIGNINGADATABASEAPPLICATIONINVB6.doc

Designing a Database Application in VB 6.0 Abstract Before you start to design a database, it’s important you understand exactly what a database is and what types of databases you have to choose from. The application type will affect the database type that you choose. What Is a Database? A database is really a system that contains many different objects used together to allow your application fast and efficient access to the data. You can use many examples of databases with your application. The most common of these are as follows: ·Microsoft Access; ·Microsoft FoxPro; ·Oracle Personal Edition 7i or 8i; and ·MS SQL Server 7.00 is only a few to mention. ??? All these databases can run on a standalone computer and allow you to create very complex databases for your applications.? Picking the right database for your application is extremely important, because the wrong one will affect performance and make your job as a developer so much more difficult. ?Before starting the design process, you need to select a database. When working with Visual Basic, the database that you can choose from fall into two distinct groups:? Local Databases can be accessed directly from Visual Basic through Visual Basic’s database Jet engine; and Remote databases cannot be accessed by using Visual Basic’s standard database access capabilities. ??? Understanding the differences will help you select the correct database for your application. However, in Visual Basic 6, there is now a way to access both local and remote databases using the same database access controls and objects known as the ActiveX Data Objects. ?Understanding Universal Data Access (UDA) ???? As databases have grown and moved off the local computer and onto networked database servers, the methods employed to access the databases have changed. Microsoft has addressed these changes by developing strategy to allow for any company or database to be accessed the same way. This is called Universal Data Access, or UDA. U