As you might expect, there is never enough information when it comes to powerful products like Access. To assist you with further investigations, I have put together a Web page with links to the Microsoft Web site, my articles, other articles, and newsgroup postings on the material in this chapter. This page includes the following:
How to set up and maintain remote queries and the In Database clause.
How to use RWOP queries.
Programming with forms as class module.
Adding database tools to Excel spreadsheets.
Setting permissions on objects by using the ADO Extensions library (ADOX).
Creating secure data access pages (DAP).
Deploying DAP over the Internet.
Two- and three- tier DAP and preventing malicious scripts.
Deploying DAPs on the Internet or your intranet.
Programmatically changing the connection string property of DAP pages.
Using FrontPage and DAP.
How to store DAP passwords in a cookie.
Interesting reading on Access Data Project security.
Documentation on MDE libraries and references.
Database Creations provides a solution for managing ADP security.
A good explanation about MDE databases and PCode.
How to save your database as an MDE or project as an *.ADE file.
Discussions on workgroup security and MDE files.
If you have a database that needs a very simple protection mechanism, try the software at Peter De Baets's Web site.
Various other links, book references, and article references.
You can find the further reading Web page for this chapter in the Downloads section of the Apress Web site ( http://www.apress.com ) or at http://www.vb123.com/map/mde.htm .