Free E-Books

Summary
This chapter has reviewed the process of creating library databases as a way to reuse your Access
code. You may find it very efficient to take your frequently used code, add it to an .accdb file,
and save the .accdb file in the .accde format. Then, load the .accde as a library in any Access
application that needs the resources provided by the library.
Keep in mind that Access does not care what extension is applied to the library file. There are
many situations in which you might want to disguise the identity of a library file by given it an
uninteresting extension such as .sys or .dll. Most users are quite familiar with these extensions,
and have no reason to use Access to explore a file with a .sys or .dll extension. However, to
some people, a file with an extension that makes it look like an Access data file of some kind is too
tempting to ignore.
The library file can be located on a file server, making it accessible to all users on the network.
Access does not care if it has to go across the network to retrieve a library file reference.


Pages:
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046