Re: Data Access Pages

It's possible in the DAP's VBScript code to open a recordset to a query.
However, you cannot "run" a query (open it directly) from VBScript, nor can
you run a macro (or VBA code for that matter) that exists in the ACCESS
database itself.

MSDS website has many articles about DAPs; start here and look at the "Table
of contents" on the left side of the page:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_2003_ta/html/odc_landAccess02_ta.asp

--

Ken Snell
<MS ACCESS MVP>


"Iain" <Iain@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB3F7608-B602-4607-B9E8-6C86A4D4D7BA@xxxxxxxxxxxxxxxx
>I have been asked if I can modify an existing Access Database based on
> queries, forms and macros to enable it to be operated over the internet. I
> am
> now looking into whether this can be done using data access pages, but
> have
> not found a way yet and I am looking for advice if this is feasible.
>
> The database is currently controlled via forms and data can be updated
> manually or by using update/append queries and macros. While I can see
> that
> data can be edited manually via data access forms, I see no facility to
> allow
> for queries/macros to be run. I can understand that a web browser has no
> way
> of knowing how to execute queries and macros, but is there another
> solution
> that I can use?
>
> Also, if there are any example of access database being controlled via web
> pages available on the internet, I would be grateful if you could advise
> their location.
>
> Thanks for any help you can offer.
>
> Iain


.

Relevant Pages

  • How do you find which Objects are called by other Objects
    ... I have an Access database which has a number of tables, ... If I want to make some changes to a particular query, ... Queries or Macros call the object I want to make ...
    (microsoft.public.access.gettingstarted)
  • Web enable Access Project - Is it possible?
    ... Can we web enaable an Access database that runs many queries and macros and ... displays several reports? ...
    (microsoft.public.access.forms)
  • Upsize to SQL
    ... My Access database uses a front end, ... I have recently upsized the back end to SOL. ... queries, macros, forms do not work because they cannot locate the new tables. ...
    (microsoft.public.access.queries)
  • listing the syntax of macro and a query
    ... I've got about 10 macros in the access database they gave me and ... fields) and the Name and SQL view of each query listed in Queries ...
    (microsoft.public.access.formscoding)
  • Re: Automating a database table update
    ... suggest (including reading up on macros in the access 2000 ... Append queries won't update ... The final forms and reports are based on the final 6 ... you would use the odbc link manager to gain ...
    (microsoft.public.access.macros)