Discussion Locked

Deploying Data Access Pages on Internet

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi.
Looking for advice on how to publish a Access XP pivot chart on our IIS4 web server. I can see the frame of the chart but no data. Also getting a error saying "unable to connect to the database" The page works fine over our lan/intranet, but not over the internet. I have looked at a couple of microsoft docs on the subject(Q291783)and a 27 pager(same title as this posting) and frankly, got overwhelmed. If any one could provide a more systematic step by step approach, I would be appreciative. I’m aware this is a very large project and a lot of areas to cover, but if I could get a simple model to work I believe I could expand from there.
Thanks!

1 reply

by twstdalby

Taken from the Access help page:

==================================================
About sharing the database connected to a data access page:

The Microsoft Access database or Microsoft SQL Server database that is the OLE DB data source for a data access page must be on a shared server or computer in order for other users to view and interact with the page in a Web browser or in a mail message.

It's a good idea to place the database on a shared server or computer before you create your page. If you move the database that the page is connected to after you create the page, you must change the OLE DB data source connection of the page. To do so, in page Design view, right-click on the database icon in the field list, and then click Connection.

Important Make sure you use a universal naming convention (UNC) path, instead of relying on the drive letter of a mapped network drive in Windows Explorer. A drive letter can vary on a computer or may not always be defined, whereas a UNC path is a reliable and consistent way for the page to locate the data source.

Although the data source of a page can only be an Access database or SQL Server database, you can make other data formats accessible from a page by using linkedtables from an Access database.

To make your data access pages as secure as possible, you must put the Access database or SQL Server database on the same Web server as the data access page.

==================================================
The second and last paragraphs are IMPORTANT!!!

This discussion is closed to new replies.