Access newbie: Access character, concept
problem:
Only solve a problem here, what is Access? Design a database management system, use Access to design a table, inquiry, and then use VB to make a form, and design the form in Access, the report is again, which is the difference between the VBA to code, we are divided into Several groups, but others don't seem to have this consciousness, I think it is more likely to call everything directly in Access.
Reply:
1. Access is a "software" combined with a front and back. That is to say, Access has both user interfaces (VB can be used to develop user interfaces); also have logic, process processing, namely VBA language (VB can also be used to do logic processing); also store data, ie in "table" Storing data. All of this is stored in a file in an MDB format (of course, it can be MDE format). Answer the above question: Access inside the access, Access.Application must be built in VB, that is, this is basically VBA programming, not VB programming. 2, Access is not a storage format, is a software. Please strictly distinguish between Access software and MDB format. The following statement is wrong: "I use VB to develop MIS systems, and the data is stored in Access.". VB Upset MDB Format (or Jet DB) is only called a format file, and it is not called to Access. In fact, the official statement is "VB's Jet Application". In addition, the files in the MDB format can also be called by other development tools, such as Delphi / PB / C / PHP / ASP / CGI .... But called only MDB files, many of the ACCESS software have functions that cannot be called. 3, some objects in Access can be called by VB, but must install Access this software on the called machine (Copy an MDB file is not enough) or install additional ActiveX control
http://www.access911.net webmaster collection
