Data Access Pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

DAPs were, I believe, introduced for that reason; but the experiences of
people I hear on these groups have been far from enthusiastic.

I think you would be best advised to take the whole thing onto a proper
web server and deliver the pages using ASP etc. If you are using Windows,
then there is no reason not to leave the data in the mdb form, and ASP is
very similar to VBA so most of the code will port easily enough.
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.
Click to expand...

There are probably hundreds, but all you will see from the client end is
a web page with data and forms...

Hope that helps


Tim F
 
Thanks to both Ken and Tim. This has confirmed that I can't do what I want to
do with Access. I don't believe my client would want to move the whole
application to a web server since the web requirement is purely for
infrequent use from outside the office so I will look at alternative
solutions.

Thanks again,

Iain
 
I don't believe my client would want to move the whole
application to a web server
Click to expand...

Not the whole thing: just the web pages. Think of it as just another front
end to the same back end.

B Wishes


Tim F
 
Back
Top