Creating Data Access Pages from Scratch - Endless Possibilities
(Page 5 of 5 )
The options that are available are almost inexhaustible (unless you get exhausted!). For example you could bring in the Microsoft Script Editor to help with some advanced formatting and page design by clicking on Script editor as shown.
Hosting the DAP on the Intranet
It is possible to save the DAP's HTM file to the web server root. When you try to place the file you may get a message as follows:
If you accept the Yes option, your default location for your DAPs will be the root directory of your web server. In this example, the option Yes is taken. Since it is now in a more public location you will receive further warnings, the first of which is, The Website uses a data provider that may be unsafe, if you trust the website, click OK, otherwise click Cancel.:
On accepting this you may get further warnings as to who is accessing this page as follows: This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise click Cancel.
With this your data access page will be placed on the web server. In this case it was saved with the file name, TestingDap.htm. Now it is accessible by using its URL, http://localhost/TestingDap.htm.
Summary
This tutorial shows how to create a data access page starting from scratch and how to host it on an intranet site. Although data base connectivity is one of the most important aspects, creating a GUI for users is equally important. One of the reasons for Microsoft Access's immense popularity is the flexibility it offers in UI design. The tutorial also treats how to modify the page once it is created, and indicates guidelines for those interested in its advanced features.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 21 
