Answers to some questions when working with an Access database

When using access, there are always some questions difficult to answer, here will be a summary of some of the problems encountered by individuals, I hope to give you a total of experience to share friends :

Can MDB format files get out of the access environment and be called by other software on a machine that does not have access?

Reply:

1. Access is a component of Microsoft office, a pre-and post-combined database "software."

In other words, access has both a user interface (VB can be used to develop the user interface), and logic, process processing, the VBA language (VB can also be used for logical processing), and the ability to store data, that is, the data stored in the table. All of this is stored in an MDB-formatted file (or in the form of MDE, of course).

Answer the above questions: Access inside design Good interface, VB must establish access.application to call, that is, this is basically VBA programming, not VB programming.

2, access is not a storage format, is a software.

Please make a strict distinction between Access software and MDB format. The following statement is wrong: "I use VB to develop MIS system, the data is stored in Access." ”。 VB down with the MDB format (or Jet DB) just call a format file, and did not call to Access, in fact, officially called "VB JET application." In addition, MDB format files can also be used by other development tools, such as DELPHI/PB/C/php/asp/cgi/c#/J #/Java/vb.net/c.net .... Call. However, the only MDB file that is invoked is the functionality that many ACCESS software has, and these development tools cannot be called.

And that's why, like, "I don't have OFFICE access installed on my system, can I call an Access database with ASP?" "And, of course, you're not using Access software at all, just using the MDB database format, which can be supported as long as the OLE DB engine is in the system." Windows 98 and later versions of the Windows operating system have built-in support for the OLE DB engine.

3, some objects in Access can be called by VB, but must be installed on the machine called Access this software (copy an MDB file is not enough) or install additional ActiveX control

4, this refers to the pure access environment refers to the use of any other software, directly using the access interface and the storage format of the environment, that is, cannot leave the Access Runtime environment. The above-mentioned ASP + mdb/vb + MDB and so on are not so-called "pure ACCESS Environment". So the problems in these environments are fundamentally unrelated to ACCESS software.

5. "I don't understand what the MDB is," answered the question: MDB is a file format in which data is organized in a specific way, and ACCESS is the default storage format for an MDB

6, "If you say that SQL is a background data repository, that access is both backstage and foreground",

Answer these questions: SQL is a "Structured query language" and should not be confused with such database software as SQL Server. SQL SERVER is a database software, but he does not have an "end user" interface, only suitable for developers to use the interface, developers can use other programming tools to develop the interface, such as VB vb.net, and ACCESS the software itself has a developer interface and suitable for " End-User "interface, which is what we usually call a combination of front and back tables.

7, "That access is both the background and the foreground, so that SQL and access can also be called, then why SQL, Access is not completely replace SQL?",

Answer the above questions: Please refer to the answer 3,access the function and SQL Server is different so does not conflict, the specific difference please refer to ACCESS Help and SQL Server Books Online

8. Can the MDB format file get out of the access environment and be called by other software on a machine that does not have access? ”

Answer the question: Yes, this is because of the support of Jet DB, and Windows 98 is built with Jet db by default, just as more than 98 of machines can browse the Web by default, and WINDOWS 95 machines must have a browser installed to browse the Web.

To learn more about database Tutorials , You can visit e-mentor Web.

Answers to some questions when working with an Access database