لطفا منتظر باشید ...
Why This Chapter Is Important
Microsoft Access is very capable of interfacing with data from other sources. It can use data from any OLEDB or ODBC data source, as well as data from FoxPro, dBASE, Paradox, Lotus, Excel, and many other sources. In this chapter, you will learn how to interface with external data sources, with the user interface, and by using code.Chapter 20, "Developing Multiuser and Enterprise Applications." They are covered in extensive detail in Alison Balter's Mastering Access 2002 Enterprise Development .Access is an excellent front-end product, which means that it provides a powerful and effective means of presenting dataeven data from external sources. Data is stored in places other than Access for many reasons. Large databases, for example, can be managed more effectively on a back-end database server such as Microsoft SQL Server. Data is often stored in a FoxPro, dBASE, or Paradox file format because the data is being used by a legacy application written in one of those environments. Text data is often downloaded from a mainframe. Regardless of the reason why data is stored in another format, you must understand how to manipulate this external data in your VBA modules. With the capability to access data from other sources, you can create queries, forms, and reports.When accessing external data, you have three choices: You can import the data into an Access database, access the data by linking to it from your Access database, or open a data source directly. Importing the data is the optimum route (except with ODBC data sources), but isn't always possible. If you can't import external data, you should link to external files, because Microsoft Access maintains a lot of information about these linked files. This optimizes performance when manipulating the external files. Sometimes a particular situation warrants accessing the data directly. You therefore should know how to work with linked files, as well as how to open and manipulate files directly.
