Abstract
When I thought about the demonstration material that I was providing with this book, three mechanisms stood out as being both relevant to your protection strategy and good database design in general:
-
Using the AutoExec macro as a springboard for your application.
-
Separating your tables and the relationships model into one database and placing all the remaining programming objects into a second database (called database splitting).
-
Savvy and proactively using VBA code for Applications (VBA) error handling.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2004 Springer Science+Business Media New York
About this chapter
Cite this chapter
Robinson, G. (2004). Providing a Solid Foundation with Good Programming Practices. In: Real World Microsoft Access Database Protection and Security. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0793-1_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0793-1_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-126-0
Online ISBN: 978-1-4302-0793-1
eBook Packages: Springer Book Archive