• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 the module code. Although both of these options protect your code from being viewed or modified by unauthorized individuals, they do not provide the differential security afforded by MDB files.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint