799
Using ActiveX Controls 24
Access database applications prepared by even the very best developers
have problems. By their very nature, database applications tend
to be fairly complicated when you consider table and query design,
forms and reports, and implementation details. All the VBA code that needs
to be written for most databases can inevitably result in coding errors. If
you??™re lucky the problem and its cause are obvious and are easy to fix. The
situation becomes difficult when you know there??™s a problem, but its source
is not immediately apparent. The worst situation for all concerned are those
bugs that silently and perniciously damage data, or the representation of data
in an application, and without any warning.
This chapter takes a look at the types of errors you??™ll encounter in Access
applications, and some of the steps you can take to uncover and repair these
little critters. This chapter largely ignores the errors caused by poor design:
those of misrepresentation of data caused by ill-designed queries, update and
insert anomalies caused by inappropriate application of referential integrity
rules, and so on.
Pages:
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520