You can give internet access to Data Access pages by hosting them on the intranet. DAP's are files with .htm extension. Look for recent articles on DAP's by Jayaram Krishnaswamy(yours sincerely) on ASPFree.com
The best way to accomplish this is to create parameric queries and create DAPs based on these queries. In a week or two you may see an example at www.aspfree.com
Your SQL query should look like this for showing meal names not on order:
-------------------------------------------------------
SELECT
MealOrder.`MealName`, MealOrder.`MealQty`, MealOrder.`Order_date`,
MName.`MealName`
FROM
`MealOrder` MealOrder right OUTER JOIN `MName` MName ON...
This is a generic solution for multiple client access to a database from a front-end across a net work.
1. Assume you have a database called "sample.mdb" for which you have written a front-end in vb using ADO. First place this in a shared folder [myDbShare] on your server called...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.