Saving as HTML

  • Thread starter Thread starter K
  • Start date Start date
K

K

I understand how to create a Data Access Page so that my
users can manipulate the data over the web. But I don't
want just one page to be available to them - I want the
whole database available over the web, running queries and
macros and printing reports, all on the one site with
everything interconnected. Is this possible?
 
Yes it is possible.
I have not heard of anyone actually doidng it with DAPs though.
It is more common to use ASP code.
Now you can use ASP.Net.
 
I believe my question is related question to "K"'s
I have a database in Access with "Contact" table and
Parent volunteer event subdatasheet "detail". Data is
entered into the subdatasheet using a form in frontpage.
That works.
The Parent table is supposed to add up all the individual
events and show cumulative hours, which it does when you
run the query in Access. The query is:
UPDATE Contact SET Contact.CumulativeHours = DSum
("HoursEvent","Detail","[NameID]=" & [Contact].[NameID])
WHERE EXISTS (SELECT * FROM [Detail] WHERE [Contact].
[NameID] = [Detail].[NameID]) That works within Access.

My question is either
1. How can I make the query run automatically within
Access every time the subdatasheet is updated, or as it
relates to "K"'s question, how can I give the user ability
to run the query to update the Contact table? I am
using .asp pages to post and see results.
I have also tried several other methods...
2. How do I get the data access page from Access to show
the data from the database in Internet Explorer(I can open
the page, but only the title of the page shows), or
3. How can I get the parent datasheet to show the sum of
a field in the child datasheet?
Any thoughts?
 
Back
Top