Connecting a database to a web page.

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Greetings.

I'd like to figure out more about Data Access Pages. Also, Can I somehow
bind a database to a "table" on an html page? and also link to that table
via Microsoft Acces, so when I update it locally, it will reflect on the
webpage?

Thank you for your help.
 
A> I'd like to figure out more about Data Access Pages.

The best is to build test database, build a page, so you will see how it
works.

A> lso, Can I somehow bind a database to a "table" on an html page?
A> and also link to that table via Microsoft Acces, so when I update it
A> locally, it will reflect on the webpage?

You don't bind the database to an existing table or even page. Access itself
will create the page with the table already linked to the data source; that
table will be in fact an Office object, rather than just plain html table.
And that object, by the way, may very well be blocked by the browser by
default out of security concerns. And it will work only in IE. But, on the
bright side, the table will be editable.

Vadim Rapp
 
The newsgroup for DAP is m.p.access.dataaccess.pages; on Google:
http://groups.google.ca/group/microsoft.public.access.dataaccess.pages

You can bind to an Access database if the mdb file is located on the same
LAN as your machine (or the machine on which the HTML page will be
displayed) and the updates will work as expected. It's also possible to
connect them over the Internet (or WAN) but you will have to use RDS and its
configuration is not easy. You will find all the references on how to do
this in the DAP newsgroup.

However, please take note that DAP won't be directly supported in Offices
2007: they will run correctly but you won't have the possibility of changing
their design under A2007; so my opinion at this moment is that their study
is probably a lost of time.
 
Sylvain Lafontaine said:
The newsgroup for DAP is m.p.access.dataaccess.pages; on Google:
http://groups.google.ca/group/microsoft.public.access.dataaccess.pages

You can bind to an Access database if the mdb file is located on the same
LAN as your machine (or the machine on which the HTML page will be
displayed) and the updates will work as expected. It's also possible to
connect them over the Internet (or WAN) but you will have to use RDS and its
configuration is not easy. You will find all the references on how to do
this in the DAP newsgroup.

However, please take note that DAP won't be directly supported in Offices
2007: they will run correctly but you won't have the possibility of changing
their design under A2007; so my opinion at this moment is that their study
is probably a lost of time.
Click to expand...
 
Back
Top