ADP Gotchas
The important thing to remember when dealing with ADP files is that there is no local storage and there are no local queries. No local storage means that you must place temp tables and lookup tables on the server. No local queries means that all of the queries in your application need to be rewritten as views, stored procedures, and functions. This can all take some getting used to.
Another important gotcha involves security. Access ADP files do not offer user-level security. This means that if you are accustomed to assigning your users different rights to different objects, you will not be able to duplicate this behavior with ADP files. The only security alternatives are to compile the project as an ADE or to place a password on ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
