data access pages...

T

Tonio

Hi,

I created a database in Access 2000 now my problem is on
how can i publish/upload my data access pages over the
internet that should be linked to my database server. What
do i need to do in order to get the data from the data
access pages/forms?

Thanks in advance.
 
A

Amy Vargo

Hi Tonio,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
You can deploy data access pages
to your intranet or to the internet. You will need to follow the steps in
the articles below and follow the
steps for the appropriate deployment scenario for your data access
pages.

For deploying data access pages to the intranet, you can use a
shared folder in which you place a copy of the .mdb file and the .htm
page.

Please see the section titled "Deployment Scenarios" in the white paper.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k
2/html/deploydap.asp


I copied the text of the second deployment type, which uses a shared
network folder from the article:

*All files are deployed by copying them to a network file share, and
default connection settings are used on the data access page.
The data access page and database are installed in a network file share,
either by sharing their current folder, or by copying them to a new
network file share. The page is opened by using either a Universal
Naming Convention (UNC) path, such as \\MyShare\MyFolder, or from a
mapped drive that points to the network file share. This is a very
simple way to deploy data access pages, but there are security issues
with this method, as explained later in this article.


For deployment of data access pages to the internet using IIS, please
review the article below and review the third and fourth deployment
scenario types in the "Deployment Scenarios" section of the white paper
above:

Q264080 ACC2000: How to Deploy Data Access Pages over the Internet

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q264080

I copied the text for the third and fourth deployment scenarios below.
You will need to review the white paper for more information on
configuration:

*All files are deployed by publishing them on a Web server, and default
connection settings are used on the data access page.
The data access page and database are installed on a computer running
IIS (and SQL Server, when using that database format). The page is
opened by using an HTTP URL, such as http://MyServer/MyPage.htm. This is
another simple way to deploy data access pages, but there are security
issues with this method, as explained later in this article.
*All files are deployed by publishing them to a computer running a Web
server, and both the data access page and server are configured to
support three-tier data access.
The data access page and database are installed on a computer running
IIS (and SQL Server, when using that database format), and the page is
opened by using an HTTP URL. However, in this scenario, the data access
page and Web server are configured to support three-tier data access,
which is more secure and can support safe data access both inside and
outside a firewall.

Good resources:

286327 ACC2002: "Deploying Data Access Pages on the Internet or Your
Intranet"
http://support.microsoft.com/?id=286327

291783 ACC2002: How to Deploy Data Access Pages over the Internet
http://support.microsoft.com/?id=291783

You should also review the article below which describes common errors:

300699 ACC2002: Common Data Access Page Deployment Errors
http://support.microsoft.com/?id=300699

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top