Access table onto webpage

H

happy_crazy_hannah

Is it possible with access 2000 to publish your tables onto a webpage? If so,
how s this done?
 
T

Tom Wickerath

You can easily create a static (snapshot in time) web page, by selecting your
table in the database window. Then click on File > Export. In the Files of
Type dropdown, select HTML Documents (*.html; *.htm). If this serves your
need, you can also automate the process using VBA code.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Is it possible with access 2000 to publish your tables onto a webpage? If so,
how's this done?
 
H

happy_crazy_hannah

Is it possible to make it so that they can sort the data (like A-Z, Z-A) on
the webpage
 
T

Tom Wickerath

I think so, if you are willing to use data access pages (DAP's). I tend to
avoid DAPs myself. These were first introduced in Access 2000, so you have
version 1 of DAP's available. There are many limitations of using DAP's,
including Internet Explorer must be installed on each client PC, along with
Office web extensions, which I believe you can only get by having a legal
copy of Office 2000 installed on each PC.

DAP's are "okay" (not great) if limited to a tightly controlled environment,
such as a company Intranet. They are not suitable for the Internet. If you
want real-time data retrieval, with sorting and without the limitations of
DAP's, you should probably be looking into ASP, ASP.NET, DreamWeaver, or some
other software package.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Is it possible to make it so that they can sort the data (like A-Z, Z-A) on
the webpage
 
T

Tom Wickerath

PS. Danny Lesandrini has a download titled "ASP Client Error Log" that you
might find useful. You can find it on this page:

http://www.amazecreations.com/datafast/download.aspx

Also, try this page:
http://www.amazecreations.com/datafast/ShowArticle.aspx?File=Articles/dsexample1.htm


Good Luck, and thanks for marking my response as an answer.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I think so, if you are willing to use data access pages (DAP's). I tend to
avoid DAPs myself. These were first introduced in Access 2000, so you have
version 1 of DAP's available. There are many limitations of using DAP's,
including Internet Explorer must be installed on each client PC, along with
Office web extensions, which I believe you can only get by having a legal
copy of Office 2000 installed on each PC.

DAP's are "okay" (not great) if limited to a tightly controlled environment,
such as a company Intranet. They are not suitable for the Internet. If you
want real-time data retrieval, with sorting and without the limitations of
DAP's, you should probably be looking into ASP, ASP.NET, DreamWeaver, or some
other software package.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Is it possible to make it so that they can sort the data (like A-Z, Z-A) on
the webpage
 
A

aaron.kempf

yes; but it is really hard to do that in real webpages.

i would reccomend getting a newer version of office; DAPs are quite
beautiful.
 
M

Michael

I have an Access database of authors of a journal I edit and have posted it
on the web along with a data access page
http://www.iicj.net/fpdb/matpage.htm. The problem I have is the data access
page stubbornly wants to read the table on my computer and not the one on the
web. I have tried to reconfigure the links, but it just keeps defaulting back
to the original link on my computer ( C:\Documents and Settings\Michael\Local
Settings\Temp\ftp27.tmp\ftp29.tmp\matpage.htm).

I am using Microsoft Office 2000 and Microsoft Front Page.

Have you any thoughts about how I can change this please?
 
Top