Lab 20 Log

  1. Submitted by
  2. How long did it take you to do this lab?
  3. This lab has revealed a little more about the ADO control and its role in creating recordsets.   With files we had file numbers (Get #1) that directed the program to a particular buffer.    Unlike arrays, files and databases are not in memory where their contents are easy to get at.   Besides the access problem, another difference between files and arrays is that because files and databases are on another device, more than one CPU can be accessing them at the same time.   A given program’s memory is private, but a file or database is public.  What problems do you foresee when multiple users (that is, their program agents) are accessing the same database simultaneously?
  4. What have you learned about Access that you didn’t know before?